Re: Stumped on Access97, ODBC, Oracle 7.3 error

On Tue, 6 Jan 1998 14:30:26 -0500, "Bruce Hair" <bhair_at_hotmail.com> wrote:

Well, unless Access has changed it - the ODBC will default to auto-commit and the changes should get flushed as soon as you leave the row. Sounds like it might be having trouble refreshing its own query when you are going back to the row. Be certain that you are on the latest version of the ODBC driver as well, (2.5.3.1.3). Oh yea - the service pack for Office wouldn't hurt either.

-Mark

P.S. I tried this here and didn't see that behavior.

>I would appreciate any help on the following problem as I am a newbie to
>Oracle 7.3. I developed some simple forms in Access97 that contain linked
>tables via ODBC to Oracle 7.3.
>
>Here is my sceneria: Change data in row A, then click on Row B, then attempt
>to change row A again. I then receive the following error message: "The
>data has been changed. Another user edited this record and saved the
>changes before you attempted to save your changes. Re-edit the record."
>
>There are no other users editing this data. I think it has something to do
>with the timing of data being committed.
>Any ideas?
>
>Thanks,
>Bruce
>bhair_at_hotmail.com
>
>
Received on Wed Jan 14 1998 - 00:00:00 CST