Autonumber

[Jane Dully]

Hi there,

I am using Access 97 and have a table with approx 390,000
entries/rows.

I have been trying to add in an autonumber field in design
view of the table, however the file sharing lock is
exceeded (i.e. too many rows to do add a unique
identifier).

Does anyone have any idea how to overcome this so that I
can add in an autonumber to each record?

Thanks a million,

Jane

 

[Gerald Stanley]

Export the table (definition only) back to the database,
add the Autonumber column then create a MakeTable query to
populate this new table with the data from the original.

Hope This Helps
Gerald Stanley MCSD

 

[John Vinson]

Hi there,

I am using Access 97 and have a table with approx 390,000
entries/rows.

I have been trying to add in an autonumber field in design
view of the table, however the file sharing lock is
exceeded (i.e. too many rows to do add a unique
identifier).

Does anyone have any idea how to overcome this so that I
can add in an autonumber to each record?

Thanks a million,

Jane

Create a new, empty table with the autonumber field (you can copy and
paste the current table, design mode only, and then add the autonumber
field). Then you can run an Append query to migrate the data; just
don't append anything to the autonumber field and it will count up.