
10-30-2017, 11:06 AM
|
Regular
|
|
Join Date: Aug 2014
Location: London
Posts: 72
|
|
Auto number ID in Access database
Hi I have a table in an Access database with about 100000 records.
The table has an ID field which is an autonumber. This ID is not used in any relationships with other tables is used to find the most recent entry for a given value in one of the other fields.
The problem is that now I need to add some records in the middle of the table. Is there anyway to renumber the records below so that the ID's remain sequential?
|
|