I have a database with quite a few large tables.
Occasionally, I will delete all the records in a couple of tables and reload them with an Append Query using a smaller specific date range I want to work with. Lately, when I run the append and try to load all the tables with all the records I am getting the following message:
Cannot open database "XXXXXXXX". It may not be a database that you application recognizes, or the file may be corrupt".
I have tried compacting and repairing the database but that did not help. When I reduce the volume of records, it starts working again. So it appears that the volume of records is what triggers the problem.
The entire database is about 2 gig in size, but these individual tables I am talking about, while quite large, are not the lion's share of the data.
Anyone have any insights into what might being going on.
Wayne