maxlocksperfile

[Guest]

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.

 

[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.

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