Different Users (startup)

[BT24]

Hello

i have a multiusers database. what i would like to know is how can i set it up so that I can have all the toolbars and such where as the users do not have access to that? right now i have the database set up so that they dont have access to tables, and querys and such. but is there anyway so that they cannot look at the database work form

Thanks for the help
BT24

 

[Orion45]

From Access if you click on Tools and then startup you have a list of things you can prevent the user from seeing. For example, unchecking the Display Database Window checkbox will not allow users to see the normal database window, only forms. However, users can still get around the startup options in a .mdb by holding down SHIFT as the application loads. You can stop this by making your application into a .mde by using the feature under Tools, Database Utilities. In my experience .mde files also run faster and compress/repair on close.

 

[BT24]

Thanks for the help,

but is there anyway so that yes they cant see the menus and tool bars but when i start it up that i can?

BT24

 

[Guest_imported]

you can use the user level security and rights. You need to create users and accounts with rights and permissions that you can tailor to exactly what you want. In 2k and XP there is a wizard that walks through it, try it first on a sample db then the real thing.
Good luck.

 

[KenReay]

Hi

You could also set up custom menus and/or toolbars in code, and display the appropriate menu/toolbar depending on the user. A custom menu/toolbar can include a restricted set of commands (eg File \ Exit only), or you could be more generous and give then access to 'innocent' opetions like Find.

regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use