J
jerryb123
I am working on splitting a simple information lookup database so that a
number of sales users will have a front end on their machine that queries
data contained in a back-end on the server. I am trying to set up the
security and permissions so that "sales" can use the backend data without
looking at it. These are the main issues that are troubling me:
1) I have set the front end to hide the navigation pane, etc., and only show
the lookup form I want the people to use, but I can't figure a way to prevent
anyone from holding down "Shift" on startup and seeing everything I didn't
want them to see.
2) When I set the permissions so that people in "sales" can't open up the
linked tables and take a look at them, it also prevents the lookup form from
working, because it draws from the data I want to hide when it generates the
results I want to show.
number of sales users will have a front end on their machine that queries
data contained in a back-end on the server. I am trying to set up the
security and permissions so that "sales" can use the backend data without
looking at it. These are the main issues that are troubling me:
1) I have set the front end to hide the navigation pane, etc., and only show
the lookup form I want the people to use, but I can't figure a way to prevent
anyone from holding down "Shift" on startup and seeing everything I didn't
want them to see.
2) When I set the permissions so that people in "sales" can't open up the
linked tables and take a look at them, it also prevents the lookup form from
working, because it draws from the data I want to hide when it generates the
results I want to show.