Write Conflict 1

[woohahee]

I get a write conflict when I try to edit any of the data in one of my tables. It tells me that another user has attempted to change the data while I was in the record. It then asks me if I want to save over the other users changes (but doesn't enable the Save button) or whether I want to Copy to Clipboard or Drop my Changes. I'm still designing this database so I know that no other user is chnaging data in my tables.
The Table is set up on a SQL Server and I use an ODBC connection to link it to an Access FrontEnd.

Please could you help me on this one.

Richard Summers

 

[LonnieJohnson]

Do you have any programs, queries or macros that built into your form that zaps the underlying table just before you send your manual changes? ljprodev@yahoo.com
Professional Development
MS Access Applications

 

[woohahee]

Not that I know of.
The Database is split between the tables on the Sql Server and everything else in the Access FrontEnd
When I try and edit the information in the Linked table I get this conflict error. If I edit it on the SQL Server then I can make any changes I want. This leads me to believe that the problem lies in my ODBC link to the SQL server. However all the other tables work fine.

 

[Cagliostro]

Maybe you opened the database fromn more than one instances of access, on the same or on different computers. John Fill

ivfmd@mail.md

 

[tlbroadbent]

Does the SQL table have any approximate data types (text, float, real...)? If so MS Access may detect a difference when comparing the current DB record to the snapshot record saved prior to the update even though no changes were made. You can avoid this problem by adding a timestamp field to your SQL table. Terry

http://members.home.net/tlbroadbent/index.htm

 

[woohahee]

Works a treat - thank you