ACC2000: Access May Appear to Hang Opening Second Instance of ADP (223249)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q223249
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

If you use any of the following methods to try to open a second instance of a Microsoft Access project, Access may appear to stop responding (hang):
  • Selecting the project from the most recently used (MRU) list in the Open Database dialog box
  • Double-clicking the Access project in Windows Explorer
  • Double-clicking a desktop shortcut to the Access project
  • Running a command line in the Run dialog box

CAUSE

This problem may occur when the size of the Access project file (*.adp) is 16,384 bytes or smaller.

RESOLUTION

Switch back to the first instance of the Access project and close it. This enables the second instance to finish opening.

To open a second instance of the Access project, do one of the following:

On the File menu, click the file that you want in the MRU list.

-or-

On the File menu, click Open, and use the Open File dialog box to locate the file that you want.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a new Microsoft Access project named Test.adp based on the Pubs database from SQL Server.
  2. Close Test.adp, and then close Access.
  3. Start Access.
  4. Open Test.adp.
  5. Start a second instance of Access.
  6. In the Open Database dialog box, click Test.adp, and then click OK.

    Note that the Open Database dialog box closes, leaving the Access window blank.
  7. On the taskbar, click the first instance of Access, and close Test.adp.

    Note that you are able to return to the second instance of Access and to finish opening Test.adp.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug KbClientServer kbpending KB223249
©2004 Microsoft Corporation. All rights reserved.