MacroScope
Programmer
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.
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.