How to Lock Out Database Window

[fannylim]

Although I have startup options to open the database in switchboard, each
time I opened it again, the database window appears. I have also cleared the
special accesss keys in the startup options and yet the window still
appears. Is there anyway to lock it out?

Fanny
Singapore

 

[Jeff Conrad]

Here is a past post of mine which may help on this issue:
Three possibilities come to mind:

First one. Maybe this?

ACC2002: Database Window Is Displayed When You
Click the Application Icon Even Though You Turned Off
the "Display Database Window" Startup Option
http://support.microsoft.com/?id=313915

Second. If you are using the using the built-in Switchboard Manager,
the Switchboard Form's Open event probably has some code similar to this:

DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Minimize

This code will minimize the Database Window, however, it will override any
setting you have in the Startup Properties to hide the window. So find those
two lines of code in the form's code module and delete them. Please note
that you may have similar code elsewhere even if you do not use the SBM.

Third:
This is written for Access 2002, but one other thing to check:
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
http://support.microsoft.com/?id=304092
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[fannylim]

Thank you for the suggestions. I'm using Access2003 and the three
suggestions didn't work after I tried them all. When the switchboard form is
open, I can still click on the file and reopen the database window.

 

[TC]

Regarding the startup options, are you setting those manually (through
the Access user interface), or through code? Remember that they don't
take effect until the next time you open the database. So if you set
them through code, this does not affect the current open - it only
affects the next open (which is usually not what you want).

HTH,
TC

 

[Jeff Conrad]

in message:

Thank you for the suggestions. I'm using Access2003 and the three
suggestions didn't work after I tried them all. When the switchboard form is
open, I can still click on the file and reopen the database window.

Could you please elaborate a bit on that last sentence?
The switchboard form opens and then you click on a file??
What "file" are you clicking on?