J
Jan Coucke
hello,
Is it possible to reset an autonumbering field in access ?
kind regards
Jan
Is it possible to reset an autonumbering field in access ?
kind regards
Jan
J
Joseph Meehan
Jan said:
Note, while, as noted, you can sort of reset the auto numbers, you can
not assure they will be consecutive. Autonumbers are nothing more than a
tool to create a unique number for each record. It does with well, although
some have reported it is possible to even screw that up. Autonumber does
not promise to be consecutive or in any specific order.
If you want to use those numbers and need consistency, then you need to
program you own number generator.
BTW It is a wise idea to do a repair and compact (see tools menu) after
deleting the filed and before creating the new one.
A
Allen Browne
Compacting the database resets AutoNumbers.
In Access 2000 and later, you can also use ADOX to set the Seed property of
the autonumber field. Example of doing this for all tables:
http://members.iinet.net.au/~allenbrowne/ser-40.html
In Access 2000 and later, you can also use ADOX to set the Seed property of
the autonumber field. Example of doing this for all tables:
http://members.iinet.net.au/~allenbrowne/ser-40.html
M
Marin Kostov
Yes, but you need to follow these steps:
Open the table in design view, and delete the Autonumber Field. (yes, little
Destruction
Then add it again - just create a new Field, make it
Autonumber and Primary Key.
If there is any other way, I will glad to know it, since this is a common
problem.
Open the table in design view, and delete the Autonumber Field. (yes, little
Destruction
Then add it again - just create a new Field, make itAutonumber and Primary Key.
If there is any other way, I will glad to know it, since this is a common
problem.