Resetting tables

[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

 

[Dennis Schmidt]

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