Click to See Complete Forum and Search --> : Auto number in access database - Urgent
Caro
Jan 5th, 2000, 05:51 PM
Does anyone know how I can change the autonumber value on a table when it has data in it - the last number is 9998 but the next one is coming up as 12924 and I want it to be 9999. Any ideas?
Clunietp
Jan 6th, 2000, 12:07 AM
an AutoNumber is called an Autonumber because it's population is automatic. For some reason, MS Access does not reset it's auto number counter after an update was cancelled or records deleted.
Maybe you can cut the data of 12xxx, and then "add a new record" and paste it into it.
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.