Microsoft KB Archive/209723

= ACC2000: Microsoft Access Appears to Hang During a Database Compact Operation =

Article ID: 209723

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209723



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
When Microsoft Access performs a database compact operation, the status bar indicates the percentage of the task that is complete. At times, the status bar may remain on one value for a very long time, and it may appear that Access stops responding (hangs). However, in most cases when this occurs, Access continues to work on the compact operation.



CAUSE
When Access performs a database compact operation, it copies each object in the database into a new database. Because different objects have different sizes, some objects require more time to copy into the new database. The value displayed in the status bar indicates the percentage of the number of objects copied, not the percentage of the total size of all objects copied.



MORE INFORMATION
For example, if your database contains a very large table, the displayed percentage can go up to 90 percent rather quickly and then remain static while Access copies the table, and it therefore appears to stop responding. The 90-percent value indicates that 90 percent of the objects have been copied; it does not indicate that 90 percent of the total processing job is complete.

