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

View products that this article applies to.

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

↑ Back to the top

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

↑ Back to the top

Cause

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

↑ Back to the top

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.

↑ Back to the top

Status

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

↑ Back to the top

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.