Microsoft KB Archive/203150

= ACC2000: Page May Close When a Database Is Opened from Start Menu/Documents =

Article ID: 203150

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q203150



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
If you have a stand-alone data access page open in Microsoft Access without a database file being open, and you then open an Access database (*.mdb) file from the Documents list on the Start menu, the data access page will be closed before the database is opened.



CAUSE
When you open an Access database (*.mdb) file from the Documents list on the Start menu, it will open in an existing instance of Access if one exists. Access cannot have both an Access Database and a stand-alone data access page open at the same time; therefore, the page will be closed.

This same behavior will occur if you try to open an Access database by double-clicking the file in Windows Explorer or by double-clicking a Windows shortcut that is pointing directly to an Access database.



RESOLUTION
In order to keep the stand-alone page open when you open an Access database, follow these steps:
 * 1) Click Start, point to Programs, and then click Microsoft Access.
 * 2) Use the Microsoft Access dialog box to create a blank database or to open an existing file.



Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb, and then quit Access.
 * 2) Make sure you close all instances of Access.
 * 3) Start Access.
 * 4) If you see the Microsoft Access dialog box, click Cancel.
 * 5) On the File menu, click New. Click the General tab.
 * 6) Click Data Access Page. Click OK.
 * 7) In the New Data Access Page dialog box, click Design View. Click OK.
 * 8) In the Data Link Properties dialog box, click Cancel.
 * 9) On the Start menu, point to Documents, and then click Northwind.

Note that the sample database Northwind.mdb opens in the existing instance of Access instead of starting a new instance.

Additional query words: DAP prb

Keywords: kbdap kbprb KB203150

-

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

© Microsoft Corporation. All rights reserved.