I have a db table with 640k records and after adding an autonumber field for a primary key, I got the "Access Error 3052 Increase MaxLocksPerFile registry" error.
So, after a bit of research, I found a few solutions including this one from Joe:
After following the solution, I still kept getting the same error so I decided to write my own routine to loop through and number the records one-by-one to achieve the same result.
However, when running my routine, it just hangs and will not go any further than a few thousand records (hours later!).
I do not get any errors at all from the db and am hoping someone will be able to help me sort it out.
I have attached a sample db with my routine in it as well.