P
Pat
Can a database be made read only for 4 out of 5 users?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steven Chicago,Illinois
Dear Pat,
I am not a MVP, so I hope one of them will confirm or correct anything I
say if it is wrong.
question: Did you split the database? front-end on the users systems and
back-end on the network?
question: Are you using access security or any other security?
1. I think it would be best if you had some type of security when they
sign on that detemined what their security setting was 1. update ok, 2.
read-only.
You could then store the current users information and security level in a
Table that could be used as a lookup whenever a form was opened. Based on the
lookup value you could set the forms property to read-only if needed.
Another way would be to have a update form and a read-only form and direct
the user to the proper form based again on the security level they signed on
with.
Another way may be the access security (I have not used it. It would be
worth at least a look at it before you build your own).
2. If the data is very highly sensitive (Like HIPPA information), you may
want to look into a way to force a signoff if they walk away from their
screen for long durations. If you allow them to get to a print button, you
may want to print their name on each page of the reports to track who did the
printing (I have had users drop confidential reports off on a VP's desk and
learned the hard way that I needed to make the users more responsible or at
least know which one did it.)
3. You may also want to check with your network guru and see about
security from the network to get at the location on the network where you
locate the back-end.
4. If you are trying to make security very tight, you will need to do some
searched through the discussions and see how to turn off certain things in
access to keep the user from getting into the Tables and design modes. You
may even want to make custom menus/custom sign on/start up form(s).
There are prior discussions that have other sources you can use for ideas.
The MVP's have crossed this bridge many times and can bring up some important
things to think about.
Good Luck,
Steve
I am not a MVP, so I hope one of them will confirm or correct anything I
say if it is wrong.
question: Did you split the database? front-end on the users systems and
back-end on the network?
question: Are you using access security or any other security?
1. I think it would be best if you had some type of security when they
sign on that detemined what their security setting was 1. update ok, 2.
read-only.
You could then store the current users information and security level in a
Table that could be used as a lookup whenever a form was opened. Based on the
lookup value you could set the forms property to read-only if needed.
Another way would be to have a update form and a read-only form and direct
the user to the proper form based again on the security level they signed on
with.
Another way may be the access security (I have not used it. It would be
worth at least a look at it before you build your own).
2. If the data is very highly sensitive (Like HIPPA information), you may
want to look into a way to force a signoff if they walk away from their
screen for long durations. If you allow them to get to a print button, you
may want to print their name on each page of the reports to track who did the
printing (I have had users drop confidential reports off on a VP's desk and
learned the hard way that I needed to make the users more responsible or at
least know which one did it.)
3. You may also want to check with your network guru and see about
security from the network to get at the location on the network where you
locate the back-end.
4. If you are trying to make security very tight, you will need to do some
searched through the discussions and see how to turn off certain things in
access to keep the user from getting into the Tables and design modes. You
may even want to make custom menus/custom sign on/start up form(s).
There are prior discussions that have other sources you can use for ideas.
The MVP's have crossed this bridge many times and can bring up some important
things to think about.
Good Luck,
Steve