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
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.