Updating large table

[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

 

[Sylvain Lafontaine]

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.