Frint End / Back End permissions question

  • Thread starter Thread starter John Morgan
  • Start date Start date
J

John Morgan

I have designed an Access database with a front end user interface
linked to a back end 'data store'.

I have given the database manager full admin group permissions for the
front end user interface and I have also given her full admin group
permissions on the back end data store (I assume I have to give the
full permissions for the data store for the full admin group
permissions to work on the front end user interface) .

Though all day to day needs are met from the user interface there will
be occasions when the database manager may need to design her own
queries making use of the back end data store tables. On these
occasions I am anxious to ensure that permission is restricted to read
only to ensure there is no accidental change of the data. .

My questions are:

1. how do I ensure 'read only' in the circumstance described above if
I feel that I have to give full admin permissions on the front end.

2. Am I right in assuming that I need to give full admin permissions
on the back end if full admin permissions on the front end are to make
sense.

3. Should I be considering some front end permission less than Admin
for the database manager (she will be adding new records, amending
records and deleting records using the front end)

Best wishes, John Morgan
 
John said:
I have designed an Access database with a front end user interface
linked to a back end 'data store'.

I have given the database manager full admin group permissions for the
front end user interface and I have also given her full admin group
permissions on the back end data store (I assume I have to give the
full permissions for the data store for the full admin group
permissions to work on the front end user interface) .
Click to expand...

What do you mean by 'admin group' Are you referring to the Admins Group
that Access offers, or is this a new group that you set up? Why does she
need this full permission?
Though all day to day needs are met from the user interface there will
be occasions when the database manager may need to design her own
queries making use of the back end data store tables. On these
occasions I am anxious to ensure that permission is restricted to read
only to ensure there is no accidental change of the data. .

My questions are:

1. how do I ensure 'read only' in the circumstance described above if
I feel that I have to give full admin permissions on the front end.
Click to expand...

Well you can't have it both ways.
3. Should I be considering some front end permission less than Admin
for the database manager (she will be adding new records, amending
records and deleting records using the front end)
Click to expand...

Yes. She doesn't need to be a member of the Admins Group to do this.
Create a group for your users and restrict permissions accordingly.
You can remove all permissions on the tables and use RWOP queries for all
data interaction. >
 
Back
Top