I have a fairly large MS Access database (6,000 records or so) across several tables. Recently something went wrong when compacting or something odd happened, the short of it is that the ID field in ...

I just tried what I said above and no luck... (i should really try this stuff out before i open my big mouth). But if you want your autonumber field to start at 1 then you could just delete your ...