Locking Down my Database

[repoman07]

Ok, I've created my database Tables, Forms, Queries and Reports and now I'm ready to deploy this application to my users....How do I create user access priviledges for my application? I want users obvioulsy to Add,Delete and Change the data via the forms I created, view and run the queries and reports I've created...but I don't want users to be able change the table structures, change the Form designs etc...So how do I set priviledges?

Thank you for your help...I'm teaching Access to myself!!!

Bill

 

[dgm]

The easiest way...

Go into startup options (Options menu -> Startup)
and select the form u want displayed when users open the database, under the Display form/Page combo box.

Remove the Check from "Display Database Window"

Remove the Check from the "Allow Full Menus"

Remove the Check from the "Allow Toolbar/Menu Changes"

Now when your users open the database, all they can run is the forms u allow them to see, or i should say, the form u set up as the startup form, and any other forms/reports accessible from there.

Of course, when u want to make changes to the database yourself, just open the database with the shift key held down. And obviously anyone else who knows about this could do it as well, so it depends how knowledgeable your users are?

This is by no means a fool proof option, but it is enough for most situations.