Repost - Couldn't Update; Currently Locked.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I still get the following error message:

Couldn't Update; Currently Locked.

If I do a Ctrl-Break it let's me delete ~10,000 records at a time.

There are 700,000 records in the table.

Any other ideas would be great!

Thanks,

Nick
 
Good afternoon


I suspect that the MaxLocksPerFile setting will have to be increased. This is
discussed in article Q102522

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query in Macro Hangs-up 3
Could not update; currently locked (updated post) 6
Record Locked errors when updating to same value 2
Couldn't update; currently locked by user Error 3
Queries & table locking 4
couldn't update; currently locked 1
SQL or maybe a hardware issue for finding lowest Repair order date or mileage 1
could not update, currently locked 4

Back
Top