Correct forms opening with database

[Stockwell43]

Hello,

I created a database which has a main menu. If I have the main menu open at
start, when I click on the icon to open the database the form pops up, I
select the form or reports and do whatever and it was great the user can not
see any of the guts only what's opened. You get to the back end by using the
shift key (which is password protected). I downloaded a password form so that
in order to even open the database you have to select your name and enter a
password. This works fine as well except when I have that form open at start
up you can see the guts of the database and when you enter the password the
whole thing is exposed.

So my question is this:

Is there a way to have the password form open first ONLY SHOWING just that
form an nothing else then, when the correct password is entered the main menu
pops up and it works exactly like before? I hope this all makes sense but if
not let me know.

Any help would be most appreciated!!!

 

[Jeff Boyce]

Several ways...

You can set the db to open to the password form instead of the main menu
form. Then, when the password form "passes", it can open the main menu.

Opening to the password form can be a setting via the Office button, the
Access options, or via a procedure, or via an "Autoexec" macro.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Stockwell43]

So you're saying I leave my database as is with the main menu as the start up
form but create a macro to over ride to open the password form first?

 

[Jeff Boyce]

No, I'm saying change what the db uses for a startup form.

Regards

Jeff Boyce
Microsoft Office/Access MVP