User interface and Permissions

[Guest]

I'm working on a small database to work in conjunction with our website. I've
got all the tables/forms/etc. done and ready to go. I've put together a
switchboard for ease of navigation, I'm having a few problems though.

I have the database set to open directly to the Switchboard, so that the
users don't start messing around with stuff. That works, but it also opens
the Access Background (with the file, edit, etc. menu, and all the shortcut
icons); is there a way to keep that from coming up as well, or minimize it
without minimzing the switchboard?

Also, When I click on the Close Application button on the switchboard, it
closes the switchboard but not Access, I'm sure this is a simply coding
issue, but I'm not sure what line(s) I need to add to get it to close access
all togethere. Can anyone help me with this?

Lastly, when I open a form from the switchboard, to enter data, I noticed
that I am able to go to design view on the switchboard and mess around with
stuff. Is there a way for me to disable this so that the users won't be able
to get into design view?

Thank you in advance for any help that anyone can offer.

 

[Guest]

1- you can change it in your startup options
Tools-Startup
check and uncheck depending on your needs (Allow Full Menus, Allow Built-in
Toolbars,...)

Also, to hide the object browser you can minimize it at startup using
DoCmd.SelectObject acTable, , True
DoCmd.Minimize

2- Simple coding issue
Application.Quit 'closes Access altogether

3- You should be deploying your db to your users as an mde, then they cannot
mess around with your forms or code....