Restarting the autonumber fields in access
I have been testing on a database and running a bunch of bulk imports - deleting them, retuning it and then .. repeat. Well I am getting the auto number field higher and higher, but there is no records in there. Is there any way to restart the numbering. I know how to rename, change the key, delete the old one and then name the new one the same. What fun but is there a better way. I came across this:
DROP INDEX ConsumerID ON Consumer;
Executed it but nothing happens, at least it doesn't reset that field back to 1.