Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Access control to Access

0 views
Skip to first unread message

MarkS

unread,
Nov 7, 2007, 6:24:00 PM11/7/07
to
Hi,
Having never done this before I need a lot of help. I need to control the
access level for multiple users. Most will have read\write rights to one or
two tables and read rights to all the other tables.
Any help would be great

Daniel

unread,
Nov 7, 2007, 9:03:03 PM11/7/07
to
This is called User Level security (tools---security---User-Level Security
Wizard). Look it up in the help or google it for more info. you can control
what each user has access to (forms, reports, tables,....), create group,
user account....
--
Hope this helps,

Daniel P

John W. Vinson

unread,
Nov 8, 2007, 1:23:05 AM11/8/07
to
On Wed, 7 Nov 2007 15:24:00 -0800, MarkS <Ma...@discussions.microsoft.com>
wrote:

Download the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it, carefully.

Get a good night's sleep.

Read it again, even MORE carefully. Secure your database step by step,
following the instructions and checking them off as you do (I've secured many
databases and *still* do so just in case). It's easy to screw up security!

If you have A2007, note that Microsoft took this security feature *out* of the
program. Grrrrr.....

John W. Vinson [MVP]

0 new messages