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 managed to delete a record on accident that aparently this half-assed system used for a 'new records' record. Now I need to find a way to add that record back in, but the only problem is this damn ...