PDA

Click to See Complete Forum and Search --> : AutoNumber

AndyK
July 31st, 2001, 02:50 PM
What can I do to fix this? When I use AutoNumber in MSAccess, if the record was deleted, the numbers become nonsequanced, they are not in order anymore, and for example, if the record #18 was deleted, the numbers in AutoNumber would be ...16, 17, 19, 20.....18 is missing, so how to "refresh" the AutoNumber? Is it a bug in MS Access or am I setting up the column for AutoNumber wrong?
James Longstreet
July 31st, 2001, 02:58 PM
you cannot reset this; this is the way it was designed to work.



Jim Hewitt
Software Developer
Liberty Tax Service
www.LibertyTax.com
Tower
July 31st, 2001, 06:51 PM
This is not bug - this is correct work.
If you have 100000 records in database and delete record #1.
After delete database need update 99999 records and this is very big transaction locking all database. This is give us more problem in multiuser environment.
All SQL server don't update Autonumber records :)))
d.paulson
July 31st, 2001, 07:54 PM
What are you trying to do? There may be other solutions to your problem.

David Paulson