Limit User access in Runtime

[ggs]

Well I finished my Incident Report DB and I thought it covered all that we had planned for. Ha!!! Now the gnomes have said that's pretty good but can we have;
There are 5 users covering 30 locations. What they want is the users to view and input only for their own location but also to have admin log in to view ALL for certain people. (all using runtime)
I'm not sure I have the right concept of it all and there seems to be little on the internet about Runtime
So my locations are stored in a query. I 'm thinking now I need a switchboard (I think i'll do my own) to be the default open form and now I need help.
So a combo box maybe of locations including admin (or similar) and some code to run the query according to the input (oh yes and the password for each user. Am I on the right track?


Funny how this Access thing sort of grows on you


The more I know about Access the more I know the more I don't know

[apr pillai]

If your database is implemented with Microsoft Access Security then take a look at the following link:

Filtering data for different Users

[ggs]

I've had a quick read through and this sounds just what I want. When it is not 10:30pm I will give this a go thankyou