Opening Access with only "Main menu" form/switchboard

[Guest_imported]

Is there a way that I can have the user open up my Access program where just a form appears and it doesn't even look like access (ie no toolbars, menus, etc.). Right now, the application opens up and the form appears, but the database window does not. This is what I want so the user cannot mess with tables and old records. It would be nicer, though, if it didn't even appear to be access so they couldn't mess with settings and the like. Is this possible?

 

[blarson0]

it will always look a little like access. To turn off as much as you can, go to the tools-startup dialog. You can turn off almost all of the toolbars, and have a form start when your database is opened. You can make the form maximize by putting DoCmd.Maximize in the formLoad() event.

Note that this isn't good security, any user who knows what they are doing can turn startup options back off.

HTH!

-Brad

 

[ggreg]

on tools startup you can put in a startup form and disable
tool/bars make sure you work with a copy before you take away the design view button or your be stuck. or make
sure you have a copy that you have the design view button.

 

[Guest_imported]

Thanks, guys. I didn't think it was possible, but worth a shot. Wayne Gretzky always said, "You don't score on 100% of the shots you don't take."

 

[comtaxdog]

You can also make a .mde file, which hides programming and takes away the opportunity for the user to modify the forms and reports. Make the modifications form the start from within the .mde file prior to deployment that eliminate the menus, database window, etc. and start the application from the switchboard or similar form. This will make it more difficult for the user to get to the tables and queries. Short of workgroup security, this may do what you want.