I
Ian
I'm just getting to grips with security for my db app, which is for the
doctors in my hospital. I've set security up with an Admin group that only
I'm in to administer the db. I have a second group, Consultants so the senior
doctors can you the db and have permission to everything except
administration activities. The last group is JuniorDocs, which is for the
junior doctors to simply enter data. I don't want to allow them to be able to
search the db or view reports. I still have the Users group but based in
previous help on this forum I've remvoed all permissions from this group and
don't use it per se. In my JuniorDocs group I cleared out all permissions
then gradually introduced permissions to try and achieve my goal. So, they
have Database Open/Run, Tables (All) Read Data/Read Design and Insert Data on
tables that are used for data entry, Forms Open/Run on only those forms that
are linked to tables requiring data entry and Reports No Permissions. When I
run the app as a user from JuniorDocs group, I can open forms that I have not
set permissions. One form, a searching form, generates a separate form with
the search results and has a button to display these results in a report.
Whilst the report won't open it gives an error message with a button to
Debug. I really don't want this being presented to my users as they can start
playing around with the code. I hope I've explained OK, but basically I want
to limit access to this group to only data entry and not present the user
with the error message box that has the Debug button.
Can anyone help,
Thanks,
Ian.
doctors in my hospital. I've set security up with an Admin group that only
I'm in to administer the db. I have a second group, Consultants so the senior
doctors can you the db and have permission to everything except
administration activities. The last group is JuniorDocs, which is for the
junior doctors to simply enter data. I don't want to allow them to be able to
search the db or view reports. I still have the Users group but based in
previous help on this forum I've remvoed all permissions from this group and
don't use it per se. In my JuniorDocs group I cleared out all permissions
then gradually introduced permissions to try and achieve my goal. So, they
have Database Open/Run, Tables (All) Read Data/Read Design and Insert Data on
tables that are used for data entry, Forms Open/Run on only those forms that
are linked to tables requiring data entry and Reports No Permissions. When I
run the app as a user from JuniorDocs group, I can open forms that I have not
set permissions. One form, a searching form, generates a separate form with
the search results and has a button to display these results in a report.
Whilst the report won't open it gives an error message with a button to
Debug. I really don't want this being presented to my users as they can start
playing around with the code. I hope I've explained OK, but basically I want
to limit access to this group to only data entry and not present the user
with the error message box that has the Debug button.
Can anyone help,
Thanks,
Ian.