Big Problem With Access Db. Does Anyone Know How To Fix It?

[landslide]

I have been searching all over the net for an answer to this question. I have found that many many people are having the same problem but I cannot find anyone with a solution to this. The problem is when you update multiple records at once it will gve you the following message. Could not update; currently locked by user xxxx. In every posting on the web it appears this only happens when you try to update multiple records at once and normally over 100 records at once. Does anyone know what causes this error and even more important how do you solve this problem?

[aussie girl]

try this
http://groups.google.com.au/group/microsoft.public.access.multiuser/browse_thread/thread/ec8d4144c05e5304/f1ba7ce2463b2217%23f1ba7ce2463b2217

[landslide]

Thanks for the reply. I double check to ensure that a stray connection was not open but none are open. Also I think this is different because I can update and insert to all of the database with no issues the problem I am having is only when I try to update multiple records at the same time. And only with more than ten records at a time. I have to keep hitting the refeash button until it finally updates all the records. Any other sujestions on this?

[buntine]

It probably has something to do with the maximum session restrictions on MS Access.

If anything, I think your best bet is to grab your data and upgrade to MS SQL! Access was never meant for the web.

Andrew Buntine.