You are currently offline, waiting for your internet to reconnect

ACC: How to Hide the Database Window When MS Access Starts

This article was previously published under Q88160
This article has been archived. It is offered "as is" and will no longer be updated.
Advanced: Requires expert coding, interoperability, and multiuser skills.

When you start Microsoft Access, the Database window is usually visible. Ifyou do not want a user to be able to gain access to the Database window, you can create an AutoExec macro that hides the Database window. This article describes how to create the macro to do this.
When a Microsoft Access database is first loaded, Microsoft Access checksfor an AutoExec macro and runs it if it exists. While the following macro willhide the Database window from the user, it can be circumvented by holding down the SHIFT key while the file opens:
  1. From the File menu, choose New to create a new database. Give the database a unique name.
  2. From the File menu, choose New, and then choose Macro to create a new macro.
  3. Add the following actions:
          Action              Comment      ------------------------------------------------------------------      SelectObject        Select an object in the Database window so the                          focus is set to the Database window.      DoMenuItem          Hide the object that has the current focus.						
  4. Set the following properties for the actions entered above:
          SelectObject Action      -----------------------      Object Type: Macro      Object Name: AutoExec      In Database Window: Yes      DoMenuItem Action      -----------------      Menu Bar: Form      Menu Name: Window      Command: Hide						
  5. From the File menu, choose Save As, and save the macro as AutoExec.
  6. Close and reopen the database.
The macro will hide the Database window. However, menu items still exist toshow the Database window. To hide these items, you can create a custom menu for your application, or use one of the following techniques depending on your version of Microsoft Access:
  • Version 1.x: Disable the Show command on the File menu.
  • Version 2.0: Disable the UnHide command on the Window menu.
For more information about custom menus, search for "customizing menus"using the Microsoft Access Help menu.
gray grey dimmed container

Article ID: 88160 - Last Review: 12/04/2015 09:16:47 - Revision: 2.0

Microsoft Access 1.0 Standard Edition, Microsoft Access 1.1 Standard Edition, Microsoft Access 2.0 Standard Edition

  • kbnosurvey kbarchive kbhowto kbusage KB88160