Timtropolis
Registered User.
- Local time
- Yesterday, 21:32
- Joined
- Jun 17, 2004
- Messages
- 84
Greetings all.
I am getting the following error when running VBA code in Access 2002.
"File Sharing lock count exceeded. Increase MaxLocksPerFile property registry entry"
This code started happening today on code that has been tested and has been running for about 2 months. The code updates information in one table with info from another. I am using DAO to achieve this and have made sure the the appropriate reference libraries are checked.
The error occurs on the .Update command that I am using in conjunction via a WITH loop. I have tried to eliminate the WITH and using RST.update but still get the same error. I also looked at the record where the code halts but have found nothing unusual with the record
If anyone could shed some light on this, it would be very much appreciated.
TIA,
Timtropolis
I am getting the following error when running VBA code in Access 2002.
"File Sharing lock count exceeded. Increase MaxLocksPerFile property registry entry"
This code started happening today on code that has been tested and has been running for about 2 months. The code updates information in one table with info from another. I am using DAO to achieve this and have made sure the the appropriate reference libraries are checked.
The error occurs on the .Update command that I am using in conjunction via a WITH loop. I have tried to eliminate the WITH and using RST.update but still get the same error. I also looked at the record where the code halts but have found nothing unusual with the record
If anyone could shed some light on this, it would be very much appreciated.
TIA,
Timtropolis
