Security of database

[Guest]

Hi

I have a database with a split front end and back end.

In the database there are various forms for entering and viewing data upon
which I have various command buttons, some are for manouvering around the
database and some are for inputing new records etc.

I have just created groups and users for security.

One of my groups is for users who can only read data.

I was wondering if it is possible to remove the buttons on the forms, for
inputting data, to prevent the read only users from even trying to input
data. I appreciate I could just remove the buttons on the front end for the
read only users, but this would be long winded.
Currently this is not a problem but there will be 'read only' people who try
and input data and that is when the questions will arise.

Any thoughts greatfully received

Richard

 

[Douglas J. Steele]

For a given user, you can determine whether or not that user is a member of
a group that can do updates, and set the Visible property of each of the
buttons to False if not.

The Access Security FAQ
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp&SD=GN
shows how to determine group membership (see sections 22 and 23)