Unanswered: Adding New Column to Access DB with AutoNumber as DataType
I have an Access Database with a Table having 2lakh records. I want to add a new Column having DataType as AutoNumber and Field Type as Primary Key.
I used the following SQL query to change the Table.
"ALTER TABLE [customer] ADD UID COUNTER PRIMARY KEY;"
It works well for some 20,000 records... but not for the table with 2lakh records. I am getting the error :"File sharing lock count exceeded.Increase MaxLocksPerFile registry entry" Please help me.....