Security

[richrich]

Hi,

I have now finished my system that will run on a windows network. I now need to get the security setup so different users can access different pages.

I have set a list of users and specified what forms/tables they can access. The problem is, how does access know who is accessing the pages? For example, i have set 2 users - Dave G & Dave S - I have given Dave G access to the admin forms as he is the admin and I have given Dave S access to the general data input forms.

How is this enforced? How does access know which person is opening the forms. Unless access asks the user to login using their user name set in access, I cannot see how it can manage what users can do what.


Thanks

 

[Smart]

I am assuming that your database is a secured dbase (with a username and password needed to login)
this being the case.

Prior to callin or opening any forms you can run a query to select from your table (holding what can and can't be opened using currentuser() in the criteria section of the query.

I wouold have a menu form with buttons for each form / table (if ther aren' to many) and on the on open of the form determine which buttons are to be available to each user.

disable any buttons that the user should not be able to access

 

[richrich]

The system starts with a menu page where the users can use buttons to go to the relevent forms. What you mention is just what I need. The admin lady can have access to the admin forms and other users to forms relevent to their job.

The database has a current username and password to access it on opening. I have made several users but this just asks for a username and ID. There is nowhere to set them a password.

If they use the current standard password, how does access know which user they are? surely to specify which forms each user can access, each user needs a username and password to log in.

 

[Len Boorman]

Have you read any articles on Access Security

L