I'm using a bound Access form, the same as I am with the other forms that
have been working for years. There is no code to create/modify/update
records; it's all being handled by the form, and it's based on a single
table. Nothing complex here. There has to be something on the SQL side, or
with the ODBC driver. But, again, there's nothing different here than with
other forms in the application with the same database, which have worked for
years.

Neil


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns95DD40B1961BYazorman@127.0.0.1...
> Neil Ginsberg (nrg@nrgconsult.com) writes:
>> Another note on this issue. If I go into an existing record, type data
>> in a field, save the record (using Shift+Enter), then immediately type
>> more data in the same field, I get the message, "The data has been
>> changed. Another user edited this record and saved the changes before
>> you attempted to save your changes." Once the message is cleared, the
>> steps of typing/saving/typing can be performed without any errors. But
>> when you first go to a record and perform those steps, the error always
>> comes up.
>>
>> This happens both on the network version of the database, as well as in
>> my personal copy (using MSDE), so I know it's not a multi-user issue,
>> but some kind of a glitch. It seems that it might be related to the
>> below message re. losing data, so I posted it here.
>
> Both this problem and the other about losing data, sounds like there are
> problem in the application. Since I don't know Access, I can't really
> say exactly what.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinf...2000/books.asp