display toolbar based on user group security

mk0920

Registered User.
Local time
Today, 07:55
Joined
Jun 22, 2010
Messages
12
I need to hide the database window and the design view button on the toolbar for all users other than myself who is the administrator.
 
Convert the front end into an mde and distribute that
 
I have no idea what that means. I am a new user, not a programmer.
 
Then perhaps it's time to get reading, Microsoft Support and google are your best friends.
 
I have spent literally hours googling and reading the 2 books I bought and reading/training on Microsoft's site. None of them address this issue. I was able to create my forms, reports, import my data from Gold Mine and set up the user security. All is well except I (the administator) need to have access to commands like design view and delete that I do not want my users to have. If I take these commands off the toolbar and menu, then I have no way to access them when I need to.
 
Hmmm, in that case, I'll give you my poor summary but you'll have to look for tutorials to get it a 100%

There's an option to split a single database file (mdb/accdb) into a Front End/Back End combo. The front end will contain the forms and reports, the back end will contain the tables and relations. Of course the forms will be linked to their tables normally just like they would if it were a single database.

This way, you can have multiple versions of the front end (make many copies and edit them) while the backend has no clue of what's going on. So now, you can have a certain front end for normal users, and another one for admins (which you will keep for yourself by password or whatever).

Of course you can then make the mdb file into an mde (or accdb to accde). This will basically not allow changes to be made to it's design.

Hope that helps
 

Users who are viewing this thread

Back
Top Bottom