I have a database that keeps crashing during Compact & Repair. The message i get is "Cannot find field 'Description'"
The trigger for the error seems to be either copying a v large table under a new name or copying all the records from this table into another
cnCurrent.Execute "INSERT INTO [Scenario] SELECT * FROM [Base]"
If I delete the table [Scenario] then the database will compact without a problem.
Unforuntately i need the user to be able to copy the whole of [Base] as a new table [Scenario] and then compact the file.
Oh one last thing - there is no field called Description!