Run Time error 3052

[Timtropolis]

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

[Uncle Gizmo]

and you read this Microsoft report ?