ACC97: Invalid Page Fault Repairing DB After Compact Attempt
ID: Q170702
|
The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
When you try to compact a database while in break mode of a module,
you receive a message telling you that the database is in use by another
person or program. If you try to repair the same database at this
point, Microsoft Access returns an invalid page fault, and then Microsoft
Access stops responding (hangs).
RESOLUTION
Make sure you close all objects before you try to compact a database. Then
you will be able to compact and repair the database without any problems.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97.
MORE INFORMATION
WARNING: Following these steps will cause a general protection fault on
your computer. Make sure you save and close any open work on your computer
before following these steps.
Steps to Reproduce Problem
- Open the sample database Northwind.mdb.
- Set a breakpoint for the IsLoaded() function in the Utility Functions
module.
- Run the function from the Debug window. This will put the function in
break mode.
- Minimize the module and select the Database window.
- On the Tools menu, click Database Utilities, and then click Compact.
- In the "Database to Compact From" dialog box, select the Northwind
database you have open, and then click Compact. In the "Compact Database
Into" box, accept the default database name, and then click Save.
- When the message is displayed that Northwind is being used by another
user, click OK.
- On the Tools menu, click Database Utilities, and then click Repair. Note
that you receive an invalid page fault.
Keywords : kbusage GnlCmp
Version : 97
Platform : WINDOWS
Issue type : kbbug