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?