Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 302484 - Last Review: January 31, 2007 - Revision: 3.1
ACC97: Error 3218 "Couldn't Update; Currently Locked" When You Delete Records in a Database on a Novell Server
This article was previously published under Q302484
Advanced: Requires expert coding, interoperability, and multiuser skills.
SYMPTOMS
When you are working in an application that connects to a Microsoft Access database on a Novell file server, and you try to delete a large block of records (for example, more than 5,000) from a table, you may receive the following error message:
3218 Couldn't update; currently locked.
CAUSE
Novell servers have a limitation of 10,000 on the number of locks per user. If the number of locks required to execute the deletion exceeds the number available, you may receive this error message.
RESOLUTION
To work around this problem, use one of the following methods.
Method 1
Increase the number of record locks on the Novell server. Contact your Network Administrator or Novell for instructions on how to do this.
Method 2
Instead of deleting records, drop and re-create the table through SQL statements.
Method 3
Delete data in smaller chunks. To do so, follow these steps:
- Create a query that selects x number of TOP records from your table, for example:
SELECT TOP 4500 * FROM MyTable
- Save the query as Query1.
- From your program, call the following SQL statement:
DELETE * FROM Query1
This will delete the top 4,500 records. You can call this query multiple times, depending on how many records you have. Even if this query is called after there are no records remaining in the table, you should not receive any errors.
REFERENCES
Microsoft Jet Database Engine Programmer's Guide Second Edition, "Chapter 9," page 426
APPLIES TO
- Microsoft Access 97 Standard Edition
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please