File Sharing Lock count Help

J

JUAN

Hello,
I created a macro that opens a table, selects all records
and then deletes; but I get following error message:
File Sharing Lock Count Exceeded. It says that the
MaxLocksPerfile by default 95OO.
And says it can be change by the Regedit.exe or
Setoption. My table is more than 100K records. Can anyone
let me know what's the easiest way and provide steps?

Thank you,

Juan
 

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 2
file sharing lock count exceeded 3
3052, File sharing lock count exceed. Increse MaxLocksPerFile regi 0
File sharing lock count exceeded. 1
Receiving File sharing lock count exceeded in Access 2007 4
File sharing lock count exceeded. Increase MaxLocksPerFile registry 4
"File share lock count exceeded" disappeared my forms 0
File sharing lock count exceeded 1

Top