maxlocksperfile

S

SHIPP

I am trying to update approximately 15,000 records. I keep on getting Error
3052: File sharing lock count exceeded. Increase MaxLocksPerFile registry
entry.

How do I get around this. This program ran fine under Access 97. We just
upgraded to Office 2003. Any ideas would be appreciated.
 
R

RD

I am trying to update approximately 15,000 records. I keep on getting Error
3052: File sharing lock count exceeded. Increase MaxLocksPerFile registry
entry.

How do I get around this. This program ran fine under Access 97. We just
upgraded to Office 2003. Any ideas would be appreciated.
Click to expand...

It doesn't look like you ever got an answer to this.

I had a similar problem a while back but increasing the MaxLocksPerFile didn't
help. What ended up helping (thanks go to David Epsom) was putting the
following in my Update loop just before my Next statement:

Application.DBEngine.Idle dbRefreshCache

This causes Access to release the locks.

Hope this helps,
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
Increase MaxLocksPerFile registry 7
Error 3052 MaxLocksPerFile exceeded 2
How do I turn off File Sharing Locks altogether? 5
File sharing lock count exceeded 2
"File share lock count exceeded" disappeared my forms 0
max locks per file 0
File sharing lock count exceeded. 1

Top