On Tue, 26 Jun 2007 06:23:00 -0700, Sid <addala.1@gmail.comwrote:
Quote:
>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...t%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
Scott McDaniel
scott@takemeout_infotrakker.com www.infotrakker.com 
