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

Article translations Article translations
Article ID: 935370 - View products that this article applies to.
Expand all | Collapse all

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.

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.

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

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:
http://support.microsoft.com/contactus/?ws=support

STATUS

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

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:
http://technet.microsoft.com/en-us/library/bb726965.aspx

Properties

Article ID: 935370 - Last Review: October 7, 2008 - Revision: 3.1
APPLIES TO
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
  • Microsoft Access 2000 Standard Edition
  • Windows Vista Business
  • Windows Vista Enterprise
  • Windows Vista Home Basic
  • Windows Vista Home Premium
  • Windows Vista Ultimate
Keywords: 
kbeventlog kbsmb kbdatabase kbregistry kberrmsg kbexpertiseinter kbtshoot kbprb KB935370

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com