Making startup form and disallowing everything else

[Faraz Azhar]

Hello

I've made some forms and all my data is entered and edited within
those forms. I've also made a switchboard from which all my forms can
be accessed. I've also added commandbuttons like Edit record, Quit
Access, etc. So there's no need for manual data adding or editing
tables, queries, or reports.

I know I can set my switchboard as the startup form from
Tools>Startup. But I want to know what settings do I have to apply
that the user cannot access the database window, or edit the form or
its code, or do anything. I just want the form to open, nothing else
to show besides the forms Ive made, and when the user clicks Quit or
closes the window then everything should close. No menus or right
click menus, etc.

Please guide me what settings I have to set. Also do I need to create
user groups or security settings ?

 

[Klatuu]

I would suggest you create an mde file and deploy that rather than the mdb
you use for development. You can hide the database window and use other
startup settings to prevent users from seeing what they should not see.
Also, no design changes can be made in an mde.

 

[Faraz Azhar]

ook .. How do I do that ? I have my mdb all ready with code and
everything.. now all I need to do is setup this structure. How do I
convert my mdb to mde ?

 

[Klatuu]

To set up the startup options, Tools, Startup
Then set the options like you want them.

To create an mde,
Tools, Database Utilities, Make MDE. Just follow the wizard.

 

[diogenes]

To set up the startup options, Tools, Startup
Then set the options like you want them.

To create an mde,
Tools, Database Utilities, Make MDE. Just follow the wizard.

Just for safety's sake, do this step on a copy of your MDB database.

 

[Faraz Azhar]

Just for safety's sake, do this step on a copy of your MDB database.

OK.. I'll do it. By the way.. what benifits does MDE bring ?