Access Security for Tables, Queries etc

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

Guest

Hi,

I am a new user to Access and I am trying to do put user level access on
tables, queries, and fields. I know how to enable/disable fields on a form
based on the user that has logged in to the Access database, but the problem
with that is that even if I were to disable it on the form, the user can
still access the table i write to and edit it there. So, I was wondering if
there is an easy way to diable the field on the form and also disable the
table itself or a field with the table. I have tried to read the Access
security User and Group Accounts, but am not I am not understanding it. Any
help you can provide would be awesome. Just as background info, I have the
following table setup

User Name Windows NT Login User Roles
John Doe John.Doe A (Administrator)
Mike Moore Mike.Moore N (Normal User)

Using this talbe, I created a select statement which finds the role of the
person that has logged in and then use it to disable certain fields on the
form, but I am not sure how to use this concept to enable/disable an entire
table and/or query. Thanks in advance.
 
Access user security is a very complex subject and all anyone here will do is
to point you to the voluminous Microsoft documentation which you can find via
google or in the MSDN library, Chapter 18.


Dporian
 
Back
Top