maxlocksperfile

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SHIPP - 25 Aug 2006 13:52 GMT

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.

Signature

M. Shipp

Reply to this Message

RD - 31 Aug 2006 18:35 GMT

>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

Reply to this Message