Customized access to the database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ramtin - 01 Feb 2007 02:47 GMT

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

Reply to this Message

Keith Wilby - 01 Feb 2007 09:18 GMT

>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
[quoted text clipped - 3 lines]
> 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

Reply to this Message