Customized access to the database

[Ramtin]

I need to set up a security which limits access of a group of users only to
the forms for reviewing , editing and entering the data; I don't want them to
have the access to tables, queries and macros; what is the best way to do it?
Any help is apprciated.
Ramtin

 

[Keith Wilby]

I need to set up a security which limits access of a group of users only to
the forms for reviewing , editing and entering the data; I don't want them
to
have the access to tables, queries and macros; what is the best way to do
it?
Any help is apprciated.
Ramtin

There are several things you need to consider doing:

1. Hide the db window using the startup options (easy).
2. Uncheck every startup option except "display status bar" and provide your
own menus and toolbars (easy-ish).
3. Disable the "bypass" (shift) key (not that easy if you're a novice).
4. Apply user-level security (difficult).

*Don't* attempt step 4 until you fully understand the subject. There's a
link on my website to some essential reading.

I'll leave you to ponder that for a while, post back when you have more
questions.

Keith.
www.keithwilby.com