98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » AutoNumber
AutoNumber
Resolved · Low Priority · Version 2007
Mon 19 Jul 2010, 10:55Delegate Lucia said...
Lucia has attended:
Access Intermediate course
AutoNumber
Hi!
I wanted to know if I can get the ID field to go back to 1 after deleting 200 records, or at least show a number decreased of 200 in the forms.
Thanks!
Lucia
Tue 20 Jul 2010, 15:03Trainer Newson said...
RE: AutoNumber
Hi Lucia
Please find a link below from Microsoft which explains how you can reset the autonumber field. I'm assuming this is a primary key. The link discusses steps for 2003 and 2007 and what to do if the primary key spans multiple tables.
YOU SHOULD BACK UP YOUR DATABASE BEFORE ATTEMPTING ANY STEPS IN THE ARTICLE BELOW
http://support.microsoft.com/kb/812718
Many thanks
Newson
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Creating Parameter wildcard queriesTo creat a parameter query that also uses a wildcard, in the query design type in like []+*. |
