Compact and Repair no longer resets autonumber ID field

[gaker10]

Title says it all. This method use to work. I have a split database.

My usual method is to delete everything in my table, which does not need to be maintained, then I Compact and Repair and re-open the form and my ID is reset to 1. Now it just continues from the last number I used.

This ID field can and will blow up pretty fast, so resetting it would be useful.

[gaker10]

SOLUTION: I compacted and repaired the back end and my ID is now reset.