Truncating Data Tables within MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Delete all Records in the Table(s) and then do a Compact & Repair ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber restarting after compact and repair 4
Append Queries 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access 2010 query for 3 tables 0
reset autonumber to '0' following delete query prior to appending 1
Append to table with 2 fields in Primary Key - last is an autonumb 1
import and append excel file to main table and sub table 9
Adding New records in multiple tables 2

Back
Top