Reset Autonumber

[Terry Holland]

I need to deploy a copy of an Access XP database to another division of our
company. To do this I need to strip out all existing data.
After doing this and compnacting on earlier versions of Access Im sure the
Autonumbers reset back to 1. It doesnt seem to do this with Access XP.
How can I get them to reset?

Terry Holland

 

[Allen Browne]

If all the data is gone, then, yes: compacting should reset the AutoNumber.

If that is not happening, check that you have SP8 for JET 4 on your
computer. Find msjet40.dll (typically in windows\system32), right-click, and
choose Properties. On the Version tab, you should see 4.0.8xxx.0. The xxx
digits don't matter, but if you don't see the 8, go to:
http://support.microsoft.com/gp/sp
and get the update.

If that still does not solve the problem, it is possible to programatically
set the Seed of the Column in the Table using the Catalog in the ADOX. But
it would be better to track down why it is not working as expected.