Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Issues that you may encounter when you open or are using a Microsoft Office Access database on a computer that is running Windows Vista


Symptoms

When you open or are using a Microsoft Office Access database on a computer that is running Windows Vista, you may encounter one or more of the following issues:

  • Access appears to stop responding.
  • Access responds very slowly.
  • Access exits unexpectedly or crashes.
  • An event that resembles the following is logged in the Application log:
    Log Name: Application

    Source: Application Hang

    Logged: Date_and_Time
    Event ID: 1002

    Task Category: (101)

    Level: Error

    Keywords: Classic

    User: N/A

    Computer: Computer_Name
    Description: The program MSACCESS.EXE version Version_Number stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Problem Reports and Solutions control panel. Process ID: Process_ID Start Time: Hexadecimal_Time Termination Time: Hexadecimal_Time
After you encounter one or more of these issues, you receive the following error message the next time that you open the database:
The document Database_Name caused a serious error the last time it was opened. Would you like to continue opening it?

When you open the database, you encounter the following issues:
  • All data in tables and queries shows as "#Name?"
  • You no longer see any objects in the navigation pane.
This problem may occur if the following conditions are true:

  • The database that you are using is a shared database that resides on a Windows Vista-based computer.
  • Two or more Windows Vista-based computers are trying to use the database at the same time.

↑ Back to the top


Cause

This problem is related to issues with Server Message Block (SMB) 2.0 when SMB 2.0 is running on a Windows Vista-based computer.

↑ Back to the top


Resolution

To resolve this problem, take one of the following actions:
  • Install Windows Vista Service Pack 1.

    For more information about Windows Vista Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

    935791 How to obtain the latest Windows Vista service pack

  • Apply the hotfix that is described in Microsoft Knowledge Base article 935366.

    For more information about this hotfix, click the following article number to view the article in the Microsoft Knowledge Base:

    935366 Access may stop responding when you open a remote database

↑ Back to the top


Workaround

You can temporarily work around this problem by sharing the database from a computer that is not running Windows Vista. We do not recommend this method as a permanent solution. You should check this article periodically for a permanent solution. Alternatively, you should contact Microsoft Customer Support Services. For a complete list of Microsoft Customer Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


More Information

For more information about SMB 2.0, visit the following Microsoft Web site, and then see the "Server Message Block 2.0" section:

↑ Back to the top


Keywords: kbeventlog, kbsmb, kbdatabase, kbregistry, kberrmsg, kbexpertiseinter, kbtshoot, kbprb, kb

↑ Back to the top

Article Info
Article ID : 935370
Revision : 3
Created on : 4/23/2018
Published on : 4/23/2018
Exists online : False
Views : 241