View Single Post
Old 10-30-2017, 11:06 AM
Daigon Ali Daigon Ali is offline
Join Date: Aug 2014
Location: London
Posts: 73
Default 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?
Reply With Quote