max locks per file

J

Judy

We have updated our crm software to run on Access 2003 front end from Access
97 front end, but are still using the Access 97 back end.
While importing a small batch of data from our ecommerce site, we got an
error 3052 file sharing lock exceeded.

I've seen these two suggestions in the newsgroup and wonder which would be
the best to use:

DAO.DBEngine.SetOption dbmaxlocksperfile,30000

and hope I guessed right about the 30000 or

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

If I use the dbRefreshCache, where do I put it? The code runs on a submit
button and the processing is using abour a dozen queries with a few of the
queries using functions to parse some stuff.

Thanks
 

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

Running code locks the database 0
How do I turn off File Sharing Locks altogether? 5
MS Access Front End - SQL Server Backend 7
File Sharing Lock COunt Exceeded Issue 3
Use or convert- Access 97 backend with Access 2003 runtime front e 1
CurrentDB - Run-Time error 70 Permission Denied 1
To move or not to move to a Terminal Server 11
Convert from Acess 2003 to 2007 5

Top