I just had an idea, that might just be a stroke of genius. I am working on a database that I want to have different levels or permissions. I want people to just use the forms and reports I create for them. These will only let you access certain things. All objects will be hidden in the Navigation Pane, but that is easy to circumvent.
Example:
Non-admin opens the database and some kind of initial navigation form is shown. Buttons that lead to forms they are not allowed to access are hidden. But this person can still unhide the objects in the navigation pane and open them that way.
This is my stroke of genius. Maybe?
On all my buttons I will pass an OpenArg in the OpenForm function. Then in the OnOpen method of that form, if the OpenArg is not correct, I will close it and display a msgbox that it can't be opened. I think this will really help achieve the security I am looking for.
What do you guys think? Will this cause any problems for users that are doing things correctly (i.e. just using my forms)? Are there still simple ways to circumvent this? Do you have any additional suggestions for this idea?
Example:
Non-admin opens the database and some kind of initial navigation form is shown. Buttons that lead to forms they are not allowed to access are hidden. But this person can still unhide the objects in the navigation pane and open them that way.
This is my stroke of genius. Maybe?
On all my buttons I will pass an OpenArg in the OpenForm function. Then in the OnOpen method of that form, if the OpenArg is not correct, I will close it and display a msgbox that it can't be opened. I think this will really help achieve the security I am looking for.
What do you guys think? Will this cause any problems for users that are doing things correctly (i.e. just using my forms)? Are there still simple ways to circumvent this? Do you have any additional suggestions for this idea?