Updating large table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large table approximately 650,000 records which I need to add an
autonumber primary key field to. I keep getting a error related to
maxlocksperfile. I have increase this value in the registry to a 1,000,000
but I still get the error. Need help. Thanks
 
Possible solution here: create a second table (maybe in another MDB file)
with a autonumber field, copy the data into this new table - using multiple
batches if necessary - then delete the old table and import the new table.

Also, try compacting the MDB file before trying to make the change.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MaxLocksPerFile error Windows 10 - Access 2013 0
Table Analyzer Help!!! 0
Add autonumber to a large table? 0
Error 3052 MaxLocksPerFile exceeded 2
File sharing lock count exceeded 2
Access 2010 query for 3 tables 0
Most efficent way to produce new table from 2 tables 2
Errors using Analyze 3

Back
Top