Error 3218: cannot update. currently locked

access , db Malaysia
  • 13 years ago

    i have  an access 2002 database being used for logging calls to a helpdesk. there are 10 users. 5 users connect through VPN and 5 are on-site. i have a copy of the database on each users computer. the tables are in a backend database on a server. when all the users are inputting logs, they get the error above when trying to go to a new record. does anyone have suggestions on how to aleviate this?

  • 13 years ago

    It sounds initially like an issue of "Primary Keys".  When you created the linked tables did you create a primary key combination?  If necessary, you will have to re-import the links and select one or more columns as the unique identifiers.  Is this a "permanent" error or one that appears only on occasion?

Post a reply

Enter your message below

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.” - Tom Cargill