When running a query that is updating a table row by row, I am getting this error message.



*************************
Run-time error 3052

File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.
*************************

Is there a way within the VBA code to correct this?