Hi, I've created a login form, but it's currently rendered useless by the Access 2007 security bar when opening the database, which disables the VBA in my form. Also, it puts a close button on the corner of my form which gives any user the option to access my data. Is there any way round this? I have already tried:
1) Fiddle with trust centre settings - this is not an option since a user could take the database to a different PC and the security bar would come back.
2) Change the VBA security setting in the registry - not an option since this would be done on form load via VBA, which is disabled.
I was thinking that maybe there is a way to invoke the security dialogue to prompt the user to enable macros or else immediately close the database.
Thanks very much.