AutoNumber Field Reset

[Guest]

I need to reset the Autonumber back to zero. Currently I have to delete a
relationship, open the table change the column from autonum to number, save
the change, change the column back to autonumber, save that change, and then
recreate the relationship.

 

[Allen Browne]

After deleting the data, try compacting the database.

If that does not work, go to support.microsoft.com, the Downloads section,
and get SP8 for JET 4.

 

[Joseph Meehan]

I need to reset the Autonumber back to zero. Currently I have to delete a
relationship, open the table change the column from autonum to number,
save
the change, change the column back to autonumber, save that change, and
then
recreate the relationship.

Normally all you need do is to compact the database.

Note:

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.