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

• Microsoft Access 2000

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 this to be a problem in the Microsoft products 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.

Additional query words: pra

Keywords          : kbdta AccessCS 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: July 28, 1999