ACC97: Invalid Page Fault Repairing DB After Compact Attempt

 Last reviewed: June 27, 1997
Article ID: Q170702
The information in this article applies to:
  • Microsoft Access 97

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. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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

  1. Open the sample database Northwind.mdb.

  2. Set a breakpoint for the IsLoaded() function in the Utility Functions module.

  3. Run the function from the Debug window. This will put the function in break mode.

  4. Minimize the module and select the Database window.

  5. On the Tools menu, click Database Utilities, and then click Compact.

  6. 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.

  7. When the message is displayed that Northwind is being used by another user, click OK.

  8. On the Tools menu, click Database Utilities, and then click Repair. Note that you receive an invalid page fault.

Keywords : GnlCmp kbusage
Version : 97
Platform : WINDOWS
Hardware : x86
Issue type : kbbug
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.