Help! Reset Auto number in table back to 0 3

[RDM23]

I have a table that I deleted all the records out of. The autonumber field continues to count from the previous deleted records. How can reset the "autonumber" ID field back to 0 in this table? Thanks in advance for your help.

 

[VRoscioli]

Tools -> Database Utilities -> Compact and Repair Database...


-V

 

[RDM23]

That didn't reset the tables auto id field back to 0. Any other options?

 

[PWise]

run this code
currentdb.Execute "insert into tablename (idfield) value (1)"

after that run compact and reapair

 

[RDM23]

My bad, the Repair and compact did work that VRoscioli suggested. I just had to clear out the table first. Thanks for all your help. Issue resolved.

 

[PHV]

Or execute an action query like this:
ALTER TABLE yourTable ALTER COLUMN yourAutoNumField COUNTER(1,1);

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886