Setting Table Auto Number back to zero

[CHEECO]

I have a number of tables that have fields that are Auto Number fields and I would like to set them back to zero. I have deleted all the records in the tables but it still wants to carry of from the last previous number. I would like it to start over again at zero. Is there an easy way of resolving this problem. Thank-you.

[RuralGuy]

Have you done a Compact and Repair yet?

[orange]

When you delete the records from all of the tables involved, run a Compact and Repair. That should reset the autonumbers.

Oooops I see Allan has responded.

[knarfreppep]

Set dbDatabase = DBEngine.Workspaces(0).OpenDatabase(gcPATH_DATA & gcDATABASE_NAME_DATA)
dbDatabase.Execute "ALTER TABLE tblTable ALTER COLUMN lngID COUNTER(0,1)"

[CHEECO]

Compact and Repair. That solved the problem Thank-you very much.

[RuralGuy]

You're most welcome and thanks for marking the thread as Solved.