Set Counter to Zero

[Brian Keanie]

I have a database which I used for an individual project. I deleted all the
data in the tables and set out on the next project. I was well into this
project when I realised that the "counter" field which is an autonumber
started at 1106 as opposed to 1. If I do the same thing again (delete the
data from the tables) how do I reset the counter to 0?

Thanks and Regards

[fredg]

On Mon, 28 Feb 2005 18:45:40 -0500, Brian Keanie wrote:

I have a database which I used for an individual project. I deleted all the
data in the tables and set out on the next project. I was well into this
project when I realised that the "counter" field which is an autonumber
started at 1106 as opposed to 1. If I do the same thing again (delete the
data from the tables) how do I reset the counter to 0?

Thanks and Regards

After deleting all the data, compact the database:
Tools + DataBase Utilities + Compact and repair

Be aware, however, that it really shouldn't matter what the AutoNumber
field number is, as long as it is unique (no duplicate numbers).

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Madhivanan]

Instead of Delete use this

Truncate Table TableName

The counter will be reset to one

Madhivanan

[Rog]

Brian,

It is not considered good practice to use an autonumber for anything
else but a record key that the users can't see, so, as fredg said, it
really doesn't matter what the number is. If this is a number you use
to lookup records it's better to use a regular number field and add 1
every time a new record is created.