Access control to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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....
 
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
Click to expand...

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]
 
Back
Top