By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,449 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,449 IT Pros & Developers. It's quick & easy.

Reset an autonumber?

P: 12
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
Feb 23 '08 #1
Share this Question
Share on Google+
5 Replies


missinglinq
Expert 2.5K+
P: 3,532
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)>
Feb 23 '08 #2

mshmyob
Expert 100+
P: 904
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
Feb 23 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
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)>
Feb 24 '08 #4

P: 30
Thank you, this is just what I was looking for!
Feb 25 '08 #5

mshmyob
Expert 100+
P: 904
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)>
Feb 25 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.