Making startup form and disallowing everything else

  • Thread starter Thread starter Faraz Azhar
  • Start date Start date
F

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 ?
 
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.
 
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 ?
 
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.
 
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.
Click to expand...

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