AutoNumber Field Reset

B

BCP

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

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