LOCKING QUESTION HELP

[Guest_imported]

Hello all. I have an Access ADP application in which I have a form that is always getting Write Conflict errors. I have been troubleshooting Access but no luck. I am trying to now look at the SQL level and locking. Any ideas on what I can do or look at? Thanks

 

[tlbroadbent]

I suggest adding a primary key or timestamp column to the linked SQL table(s). You'll need to relink the tables in Access after doing so. That will probably correct the problem. If not, check out the following articles for more info and ideas.

http://support.microsoft.com/support/kb/articles/Q280/7/30.ASP

http://support.microsoft.com/support/kb/articles/q225/9/26.asp

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin