read-only users

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I used the security wizard to set-up user level security
on a database which a main menu with navigation buttons to
several data entry forms, plus forms for reports, etc...

I set up a read-only group who I would like to only be
able to look at all the forms and run reports. This works
OK with the exception that when the read-only user
navigates (via a command button) from the main-menu to any
forms which are data-entry only, they get a blank form
that doesn't even have navigation buttons to get back to
the main menu.

Preferably I'd like them to just be able to view the form
and use the navigation buttons to get back to the main
menu.

Alternately, if I could restrict access to all the forms
except the reports form, I guess that would work also.
Note: I tried to do this by clicking off the Open/Run
permission for the Read-only group for all forms except
the main-menu and the reports form. However, when I tried
this out as a the read-only user, I could still click on
the navigation button from the main menu to any of the
data entry forms, I then got a message that said that I
didn't have permission to do this, and then kicked me out
of the database (not very user friendly).

Can you help.
 
Todd said:
I used the security wizard to set-up user level security
on a database which a main menu with navigation buttons to
several data entry forms, plus forms for reports, etc...

I set up a read-only group who I would like to only be
able to look at all the forms and run reports. This works
OK with the exception that when the read-only user
navigates (via a command button) from the main-menu to any
forms which are data-entry only, they get a blank form
that doesn't even have navigation buttons to get back to
the main menu.

Preferably I'd like them to just be able to view the form
and use the navigation buttons to get back to the main
menu.

Alternately, if I could restrict access to all the forms
except the reports form, I guess that would work also.
Note: I tried to do this by clicking off the Open/Run
permission for the Read-only group for all forms except
the main-menu and the reports form. However, when I tried
this out as a the read-only user, I could still click on
the navigation button from the main menu to any of the
data entry forms, I then got a message that said that I
didn't have permission to do this, and then kicked me out
of the database (not very user friendly).
Click to expand...

The detail section of a form will be totally blank if it has no records to
display and also does not allow new records to be added. If you moved your
navigation buttons to the form header or footer they would still be
visible.
 
Todd

You could make a copy of the form with a name
like "FormReadOny" and set the forms Allow Edits, Allow
Deletions, Allow Additions, and Data Entry all to [NO].
This would allow for viewing but not changing data in the
table.

You can then give permission to the read only group to use
this form and restrict them from using the original.

Bevnz
 
You could test for the permissions of the user - if read only don't open
forms... or open form with data entry = false... etc. I wouldn't advise
duplicating forms... that can quickly become a nightmare to manage.

HTH.

Tom.
 
Back
Top