In Access 97, is there an easy way to reset an autocounter?
Or, maybe, more generally speaking, is there a way to "reset" your database? Meaning, I've done all my testing and I want to clear the data, reset counters, etc... Is there a simple command for this? I've looked around some and not found anything in the Help or by searching these forums.
I guess, I could always break the links to the field change it to "number" then change it back? That seems icky, though.
Or, maybe, more generally speaking, is there a way to "reset" your database? Meaning, I've done all my testing and I want to clear the data, reset counters, etc... Is there a simple command for this? I've looked around some and not found anything in the Help or by searching these forums.
I guess, I could always break the links to the field change it to "number" then change it back? That seems icky, though.