**Response/more questions inline
below:
----- Original Message -----
From: "Yukon" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Tuesday, August 23, 2005 12:24
PM
Subject: [AccessDevelopers] Re: Access
Security
--- In [email protected],
"Toby Bierly" <[EMAIL PROTECTED]...> wrote:
> Never played with Access' security before. I have Access 97 at
work. I have been reading the Help file on User-level Security but am
still unclear on a couple things.
>
> In a database I was programming for Human Resources, I have a ODBC
table linked from an SQL database. It contains sensitive payroll
information as well as the data that HR needs.
>
> Is it even possible to set it so that the HR guys can't even read
specific columns in the linked table?
I've used the user level security on a pretty regular basis and
unfortunetly it only goes to the table/query/form/report/module level.
What you could do is limit the access to the data by ensuring that
people can't get to the database window and limit the access to
prevent anyone but those authorized to view all the data, change/write
any new queries or reports. That way you could design some general
reports to show them the information that they need to see.
> Never played with Access' security before. I have Access 97 at
work. I have been reading the Help file on User-level Security but am
still unclear on a couple things.
>
> In a database I was programming for Human Resources, I have a ODBC
table linked from an SQL database. It contains sensitive payroll
information as well as the data that HR needs.
>
> Is it even possible to set it so that the HR guys can't even read
specific columns in the linked table?
I've used the user level security on a pretty regular basis and
unfortunetly it only goes to the table/query/form/report/module level.
What you could do is limit the access to the data by ensuring that
people can't get to the database window and limit the access to
prevent anyone but those authorized to view all the data, change/write
any new queries or reports. That way you could design some general
reports to show them the information that they need to see.
**That's what I was afraid
of. Building a custom toolbar and disabling the special keys seems like a
lot to do to simply secure a table. Further, I might want to allow them to
create queries. Again, I could build some forms and reports, but it seems
like it is a lot of trouble. What would be nice is if I could just disable
the Tables from being accessed via the Database Window. These users
aren't advanced enough to be able to write update queries. I guess the
idea is that if they have access to queries, they basically have access to the
tables anyway, so the way to limit that is to disable the database
window.
> I'm guessing if I set up User-level Security, I could get it to
where at least they couldn't change the data in the table, but I'm not
sure if I can deny read access to certain columns.
>
> Also, if I try setting up a Workgroup Information File, how do I
limit the settings so they only apply to a single database. I may be
confused, but it seems from what I read in Help that the Workgroup
file affects all Access databases.
The workgroup file will work with any database that you open the
database through the workgroup. In general I leave myself and my
users attached to the default workgroup file but create a shortcut
that allows them to open the relevant database.
> I'm guessing if I set up User-level Security, I could get it to
where at least they couldn't change the data in the table, but I'm not
sure if I can deny read access to certain columns.
>
> Also, if I try setting up a Workgroup Information File, how do I
limit the settings so they only apply to a single database. I may be
confused, but it seems from what I read in Help that the Workgroup
file affects all Access databases.
The workgroup file will work with any database that you open the
database through the workgroup. In general I leave myself and my
users attached to the default workgroup file but create a shortcut
that allows them to open the relevant database.
**How do you know if you are in a
Workgroup? Can you change Workgroups? How do you leave "users attached to
the default workgroup file but create a shortcut that allows them to open the
relevant database"? Is this the same as applying a Workgroup to a single
database?
If your question pertains more to the using different access levels
for different users in different databases the same workgroup will
allow you to set different accesses for users in seperate databases.
**I just don't want to accidentally make it so users
have to log into all databases where they currently do not have to, with no
User-level security set up. I trying to figure out how to apply security
to a single database without affecting any other, and then figure out if I set
this up, will it really do what I want.
**For instance, if I denied read access to a table,
will the queries that are the source for the form that the users use no longer
be able to access that table either? Maybe I can do what I want by
creating a View in the SQL database and then link to that.
One final suggestion I would hesitate to set up permissions based on
users, instead define several groups for your users and define your
permissions at a group level.
Hope that helped.
Mike
**Thanks, Toby
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a href=""http://us.ard.yahoo.com/SIG=12hnr1lkp/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124832310/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org">http://us.ard.yahoo.com/SIG=12hnr1lkp/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1124832310/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
- Visit your group "AccessDevelopers" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
