ACC2000: Microsoft Access Appears to Hang During a Database Compact Operation (209723)
The information in this article applies to:
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.
REFERENCESFor more information about compacting a Microsoft Access database, click Microsoft Access Help on the
Help menu, type compact an access database or access project in the Office Assistant or
the Answer Wizard, and then click Search to view the topics
returned.
| Modification Type: | Major | Last Reviewed: | 6/29/2004 |
|---|
| Keywords: | kbprb KB209723 |
|---|
|