Re: Setting Access user level security

On Tue, 26 Jun 2007 06:23:00 -0700, Sid <addala.1@xxxxxxxxx> wrote:

I hope somebody could help me with this.

I have a access database which includes some forms, queries and
tables. Once I upload it on to the office network, I was hoping if I
could set up security for the database such that certain users can
only access certain forms based on their designated office dept.


I am not sure how this functionality could be achieved.

Access User Level Security can do this, but it's not a trivial exercise. Here's the security FAQ:

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp

Also Joan Wild's site:

www.jmwild.com

Joan's site includes a link to JacK MacDonald's excellent writeup on ULS, which is (in my opinion) required reading for
anyone looking to setup ULS.

When you move your database to the network, you'll also need to move the security file (the .mdw or "workgroup" file) to
an accessible location on the network, then use that file when opening the file on each user's workstation. Generally
this is done with a shortcut, with the Target setup like this:

"Full path to msaccess.exe" "full path to your database" /wrkgrp "full path to your security file"

Also, ULS has a newsgroup devoted to it: microsoft.public.access.security






Thanks,
Sid

Scott McDaniel
scott@xxxxxxxxxxxxxxxxxxxxxxxxx
www.infotrakker.com
.

Relevant Pages

  • RE: system.mdw netowrk issue
    ... this is unrelated to the permissions on the network drive, ... >Microsoft Security Bulletin MS03-026? ... >| Both the database, and the MDW file reside in a shared ...
    (microsoft.public.access.security)
  • Re: Replication/Sychronization and security
    ... > require security because it contains medical data. ... > network with folder level security and the network has a very slow ... Replication is not for solving application performance issues. ... > database to decrease the potential for breach. ...
    (microsoft.public.access.replication)
  • Re: How to impose security on access database
    ... > security using User Group permissions and User Level Secuirty Wizard. ... Can authorized users open the database? ... > file,copy it to your machine or an accessible network location." ...
    (microsoft.public.access.security)
  • Re: Why is Access corrupting & crashing so much??
    ... The most frequent cause of corruption will have something to do with your ... You may need to get your network specialists to do some testing. ... Access Security: www.ltcomputerdesigns.com/Security.htm ... > I am running an Access 2004 split database. ...
    (microsoft.public.access.security)
  • Re: Setting Access user level security
    ... Once I upload it on to the office network, ... Access User Level Security can do this, but it's not a trivial exercise. ... anyone looking to setup ULS. ...
    (comp.databases.ms-access)