Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help creating user level security in Access 2010

Status
Not open for further replies.

MacroScope

Programmer
Jul 17, 2010
286
US
I want to create user-level security within Access 2010. I know it's not offered, but it's not hard to use an autoexec macro to open a page that contains only user name and password entry controls, and then create my own security levels and permissions from there.

The issue I'm struggling with should be simple. The page that opens will be in modal mode so nothing can happen until it is closed, and there is a close command when the password/username match. So far, so good.

The problem is that the tab at the top is still visible, and if you right-click it you can close the form. Even if there were a way to programatically control the Access Options to disable tabs, it requires closing and re-opening the DB to effect the changes, so that seems out.

Is there some solution or some command I'm not aware of that will disable either the tab or the close option on it?

I really don't foresee much problem implementing what I have in mind, but the whole thing falls apart if it's defeatable with a right-click.

As always, assistance is appreciated.
 
Another possible solution would be to disable right-clicks until after the page closes, but I've not seen any method for doing that, either.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top