|
-
July 31st, 2001, 02:50 PM
#1
AutoNumber
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?
-
July 31st, 2001, 02:58 PM
#2
Re: AutoNumber
you cannot reset this; this is the way it was designed to work.
Jim Hewitt
Software Developer
Liberty Tax Service
www.LibertyTax.com
-
July 31st, 2001, 06:51 PM
#3
Re: AutoNumber
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  ))
Andy Tower
-
July 31st, 2001, 07:54 PM
#4
Re: AutoNumber
What are you trying to do? There may be other solutions to your problem.
David Paulson
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
