Truncating Data Tables within MS Access

[Guest]

Hi,

I'm trying to figure out how to remove all the records from a database table
and start the AutoNumber sequence over starting from 0,1,2. It seems that
when I remove the records it picks up where it left off as far as assigning
an AutoNumber to the record. The AutoNumber field is the Primay Key also.

Any suggestions would be great.

Thanks In Advance.

-- Nino

 

[Van T. Dinh]

Delete all Records in the Table(s) and then do a Compact & Repair ...

 

[Guest]

That worked!! thanks Van.

Delete all Records in the Table(s) and then do a Compact & Repair ...