"File sharing lockcount exceeded. Increase MaxLocksPerFile registr

C

chun

I got this erro when I was trying to update a ado recordset in access. Can
somebody help please? Thanks in advance!
 
R

RD

Chun,

Try this:
Application.DBEngine.Idle

This will force Access to release the locks.

HTH,
RD
 

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

file sharing lock count exceeded 3
maxlocksperfile 1
Access MaxLocksPerFile error Windows 10 - Access 2013 0
Increase MaxLocksPerFile registry 7
Increase MaxLocksPerFile 7
MaxLocksPerFile 1
Error 3052 MaxLocksPerFile exceeded 2
File sharing lock count exceeded 2

Top