The AutoExec Macro runs some third party code* and opens Form1 which prompts for a valid Registration number (used by the third party code).
If a user bypasses the AutoExec macro and opens the Database window**, they avoid Registration and can open any Form they like - effectively - use the application normally.
So, I imagine (now I’m guessing here gentlemen) some vba in, say, the OnClose Event of Form1 to change something (a Global variable perhaps??) to True. Then, All other Forms check that Global Variable for “True” in their OnLoad Event.
That way, although the user would see the names of my Forms in db1.mde database Window but, he’ll not be able to open any of them except Form1 – and Registration.
Any help would be much apreciated
*Third party Registration Module is Keyed Access from www.PetersSoftware.com
** according to: http://www.techrepublic.com/blog/10things/10-tips-for-securing-a-microsoft-access-database/552
If a user bypasses the AutoExec macro and opens the Database window**, they avoid Registration and can open any Form they like - effectively - use the application normally.
So, I imagine (now I’m guessing here gentlemen) some vba in, say, the OnClose Event of Form1 to change something (a Global variable perhaps??) to True. Then, All other Forms check that Global Variable for “True” in their OnLoad Event.
That way, although the user would see the names of my Forms in db1.mde database Window but, he’ll not be able to open any of them except Form1 – and Registration.
Any help would be much apreciated
*Third party Registration Module is Keyed Access from www.PetersSoftware.com
** according to: http://www.techrepublic.com/blog/10things/10-tips-for-securing-a-microsoft-access-database/552