Microsoft KB Archive/104827
ACC1x: Database Corruption Error After Large Action Query
The information in this article applies to:
- Microsoft Access versions 1.0, 1.1
Running a large action query, or importing a large number of records (resulting in a table size of approximately 80 MB or more), results in the error message:
'|' is corrupt or isn't a Microsoft Access database
This error occurs if Microsoft Access runs out of the memory it has allocated to keep track of a table's indexes while you are inserting keys into an index.
When this memory space is completely filled, Microsoft Access cannot proceed with the append, and it cannot discard the new information that has been temporarily stored. Microsoft Access knows that the task has not been completed successfully, and assumes that the database is corrupted. However, because nothing was actually written to the database, the data is not damaged. You can compact the database to make the data usable again.
For example, to carry out a large append, remove the table's indexes, complete the append, and then add the indexes again. Be sure not to remove the primary key if it is a Counter, because you could encounter the 4-MB transaction limit when you attempt to add the Counter key back to the table.
Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0 and 1.1. This problem no longer occurs in Microsoft Access version 2.0.
Additional query words: pagedescriptors
Keywords : kberrmsg kbusage
Issue type : kbbug
Last Reviewed: November 4, 2000