By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,706 Members | 1,105 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,706 IT Pros & Developers. It's quick & easy.

Setting Access user level security

P: n/a
Sid
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.
Thanks,
Sid

Jun 26 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Tue, 26 Jun 2007 06:23:00 -0700, Sid <ad******@gmail.comwrote:
>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

>

Thanks,
Sid
Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
Jun 26 '07 #2

P: n/a
Sid
On Jun 26, 10:20 am, Scott McDaniel <scott@NoSpam_Infotrakker.com>
wrote:
On Tue, 26 Jun 2007 06:23:00 -0700, Sid <addal...@gmail.comwrote:
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...rt%2Faccess%2F...

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@takemeout_infotrakker.comwww.infotrakker.com
Thanks Scott

Jun 26 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.