Compact and Repair - Reset Autonumber field (1 Viewer)

[Rob601]

I know it's possible, however unwieldy, to compact and repair a database in code, but I'm looking for a way to reset an autonumber counter and continue running code. Compact and repair won't work because it closes the database. Is there another way to reset the autonumber counter besides compact and repair?

Thanks!

 

[robthedog]

I know it's possible, however unwieldy, to compact and repair a database in code, but I'm looking for a way to reset an autonumber counter and continue running code. Compact and repair won't work because it closes the database. Is there another way to reset the autonumber counter besides compact and repair?

Thanks!

Could you continue running the code when the db re-opens by setting a flag somewhere before compacting which is checked when the db opens.

Rob