File Sharing Lock Count Error, Please Help!

[PantoKing]

Hello,

I am getting the following error message:-

"File Sharing Lock Count Exceeded, Increase MaxLocksPerFile registry entry."

This occurs when I am looping through records in a recordset and updating the value.

This bit of code used to work perfectly in Access 97 but since I have converted to Access 2000 I am getting this error.

Has anyone get any ideas on how to solve this.

Cheers,

Steve. Make things as simple as possible — but no simpler.

 

[erogla]

This happens when your recordset becomes so large and Accesss runs out of memory. It gives you this error even though there is no one else operating the DB other than you. What works for me is to break down the recordsets into smaller bits. This adds coding but solves your problem. It also makes your program run faster.

 

[PantoKing]

Thanks for the response.
It's sorted now though. I had declared the recordset as a dynaset and it didn't like going past 9494 records.
Cheers,
Steve. Make things as simple as possible — but no simpler.