Microsoft KB Archive/223249

= ACC2000: Access May Appear to Hang Opening Second Instance of ADP =

Article ID: 223249

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.
 * 1) 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.

Additional query words: pra

Keywords: kbbug kbclientserver kbpending KB223249

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.