ACCESS Database Resetting Auto Increment Number

Forum Moderators: open

Message Too Old, No Replies

ACCESS Database Resetting Auto Increment Number

ACCESS Database Auto Increment

rosel

2:38 pm on Jan 22, 2007 (gmt 0)

Hi everyone,

I am new to ACCESS. I have a client that has a working database, and they want all the data cleared out. I see deleting the records in MDB is simple, but I can't get the database to reset the AutoIncrement number.

Essentially what I want to do is create a clone database with no records, or get the Auto_Increment field to restart from 0.

Does anyone have info on this?

thanks -

mattur

2:47 pm on Jan 22, 2007 (gmt 0)

The Compact and Repair process will reset all empty table auto-increment counters to zero. So, delete all the records then:

Tools -> Database Utilities -> Compact and Repair Database

rosel

3:34 pm on Jan 22, 2007 (gmt 0)

Thank you so much!