ACC2002: The Database Window Is Displayed When a Database Is Opened from the Most Recently Used File List Even After You Clear the "Display Database Window" Check Box (304092)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q304092
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

After you click to clear the Display Database Window check box in the Startup dialog box on the Tools menu, the Database window is still displayed after you close the database startup form and then open the database from the most recently used file list on the File menu.

CAUSE

This behavior occurs because the Database window is only hidden when you close the startup form. The Database window is not closed.

RESOLUTION

To prevent the Database window from being displayed when you close the main startup form, add the following code to the Close event of the startup form: 
Application.CloseCurrentDatabase

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Start Microsoft Access 2002.
  2. On the Help menu, point to Sample Databases, and then click Northwind Sample Database.
  3. On the Tools menu, click Startup.
  4. In the Startup dialog box, click the arrow in the Display Form/Page box, and then click Main Switchboard.
  5. Click to clear the Display Database Window check box, and then click OK.
  6. Close the database.
  7. On the Help menu, point to Sample Databases, and then click Northwind Sample Database.
  8. Close the Main Switchboard form. At this point, the Microsoft Access application window is blank, which may lead you to think that the database is closed.
  9. On the File menu, click the Northwind sample database in the most recently used file list. (The Northwind sample database should appear as the first file in the list.)

    Note that the Database window is displayed.

REFERENCES

For more information about the Application Object, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type application object in the Office Assistant or the Answer Wizard, and then click Search to view the topic.


For more information about the CloseCurrentDatabase method, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type closecurrentdatabase in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kbdta kbprb KB304092
©2003 Microsoft Corporation. All rights reserved.