resetting the key field

[diversoln]

I've been testing a prototype db and have it ready to implement. During the testing phase I've entered lots of hypothetical data to test the operation of the db. I've now scrubbed this data but when the users begin to enter live data, I'd like the key to start at 1 again.

Is it possible to reset the key after the prototyping is complete?

 

[mission2java_78]

I've been testing a prototype db and have it ready to implement. During the testing phase I've entered lots of hypothetical data to test the operation of the db. I've now scrubbed this data but when the users begin to enter live data, I'd like the key to start at 1 again.

Is it possible to reset the key after the prototyping is complete?

Delete all bad records, and compact and repair.

Jon