Autonumber reset (1 Viewer)

[KelMcc]

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.

 

[KelMcc]

Yeah, I had to wipe the db, unbreak the links then save the autonumber field as something else, then swap it back and that worked. Fortunately, it is still in test mode so I didn't lose any data of value.

Thanks Pat.

 

[Fastone]

I will have to do this soon as well. Is there really no easier way (I'm using 2000)? Or did Microsoft forget to put it in.

 

[emcf]

i reset an autonumber field using the method Pat desribed above (delete all records then compact)....this worked but now whenever i try ro add a new record via a form a warning box appears and says 'record cannot be updated'. once I click on OK then I can update the record freely. how can i get rid of this warning box? it is a minor point but it is irritating me!

 

[emcf]

the problem seemed to be with the form...i created a new form from scratch and the problem was no longer there. anyone got an explanation for this?