Start-up Option - hide database window, doesn't always work 1

[JoeF]

I created a database and don't want the users to see the database window. I have the startup options set so that the database opens to a form on startup and the database window is not shown. When you first open database, this works fine. However, if you close the form (leaving Access open) and then open the database back up, the start-up options no longer apply. How do I prevent this from happening?

 

[Rohdem]

You could use code to hide it using the 'on open' of your first form:

CurrentDb.Properties("StartUpShowDBWindow&quot = False
Mike Rohde
rohdem@marshallengines.com

 

[PaulF]

disable the close button on your startup form, or add code to Quit Access if the user closes your form other than by the method(s) you want them to.

PaulF