Hi,
I got an error with my Msaccess DB. multiple users are using this DB's frontend. I do not know why I am getting this error message as follows
Error 3218 Could not update; currently locked
can someone help me please......
A:
Get everybody out of their mdb files. Someone might be trying to update the same record. It might even be you, in another instance active on your PC.
Beth
2010-10-28 20:07:24
+1
A:
The elephant in the room here is that multiple users are using the same front end. This is generally the first step down the road of access pain that often leads to access getting tarred with the “Access is not fit for more than 5 users” brush.
First thing is to get every user to have their own copy of the front end on their local drive. You can use the excellent access auto FE updater to make rolling out a new version easy
www.autofeupdater.com
Kevin Ross
2010-10-29 07:11:13
Good catch on that. The error message might be thrown by users contending for one of the system tables -- I read it as it only being a back end table for which there was contention.
David-W-Fenton
2010-10-30 00:10:37