How to add auto-generated unique identifier field to existing table

[dchang69]

Have a table with data in it and I want to add a new field to uniquely identify each record (simple numerical sequence like 1, 2, 3, 4.....). I don't know VBA and don't know SQL.



Tried opening the table in design view, adding a new field with "autonumber" as the data type but get the following error msg: "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry". The table has about 750,000 records in it.

Any help would be appreciated. Thanks in advance.

[tanvi]

Mentioned error message occurs when one or more database users process many transaction in a multi-user environment and number of locks required to perform a transaction exceeds the maximum number of locks per file. You can fix this error by increasing the maximum number of locks per file. To do this follow below KB article:

http://support.microsoft.com/kb/815281

Note: Backup the registry before modification.