Reset an autonumber?

[burger54]

I just finished debugging my database for errors and was wondering if there is an easy way to remove all the data and reset the autonumber's to 0?
I am using Access 2007.
Thanks

[missinglinq]

Depends on your definition of "easy!" The first thing that comes to mind is to create a new database and import all your objects into it. When selecting the tables, click on Options, then under Import Tables select Definition Only.

Linq ;0)>

[mshmyob]

You can DELETE ALL your records in the table that have the autonumber in it. After deleting ALL records you can COMPACT the database and it will restart at 1.


Cheers,

I just finished debugging my database for errors and was wondering if there is an easy way to remove all the data and reset the autonumber's to 0?
I am using Access 2007.
Thanks

[missinglinq]

Sorry! I didn't mention this because reports are that it doesn't always work! But it's such a simple answer that it's certainly worth trying first!

Linq ;0)>

[zaankanter]

Thank you, this is just what I was looking for!

[mshmyob]

Are you saying I only have SIMPLE thoughts Linq.... Now you sound like my wife. lol

Sorry! I didn't mention this because reports are that it doesn't always work! But it's such a simple answer that it's certainly worth trying first!

Linq ;0)>