In Microsoft Access, you can add records to an existing table that already as data and resize the columns that contain the fields and data, especially if there is not enough space within the columns ...

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 ...