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

Reset AutonumberID

P: n/a
I (think) I'm done designing a "Log in Sheet" for a database and need
to import the old Excel file that has ID numbers already -
How can I clear the autonumbering in the database so
1. the imported numbers will be the same as in the Excel file
2. new entries will start where those left off.

Thanks!

-warning e-mail address altered- arthureNOSPACE@
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
After deleting the test records from the database, compact it:
Tools | Database Utilities | Compact

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"arthur-e" <ar*****@ix.netcom.com> wrote in message
news:so********************************@4ax.com...
I (think) I'm done designing a "Log in Sheet" for a database and need
to import the old Excel file that has ID numbers already -
How can I clear the autonumbering in the database so
1. the imported numbers will be the same as in the Excel file
2. new entries will start where those left off.

Thanks!

-warning e-mail address altered- arthureNOSPACE@

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.