Resetting tables

  • Thread starter Thread starter Paul Hayes
  • Start date Start date
P

Paul Hayes

Have a table I want to reset that use automeric numbers
for the index (key). I have deleted the enhtries in the
table because I want to start again, but the index keeps
incrementing from it's previous value. I want to the
index, or record from 0, not for example 7. How do I do
this?.

Your help would be great.

Thanks

Paul
 
Hi Paul,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

You can reset the counter one of two ways. With all the records deleted:

1-Delete the field and add it back again.
OR
2-Go To Tools | Database Utilities | Compact and Repair Database

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
Back
Top