Backend password security warning

[jspencer]

I have a database that will be used by many users. It is split into a backend and a front end. The backend is connected to a Power BI model and therefore I cannot use the built in password feature in Access. I made a form that acts as a login dialog if the user needs to access the backend that prompts them for a password. The problem I have encountered is that when a user opens the backend for the first time, a security warning banner comes up that says "Security Warning: some active content has been disabled." and has a button that says enable content. This warning allows the user to bypass the login form by using the close button on the form. Is there a way to stop this warning from coming up for all my users? Is there a way to design and place the form such that the warning won't allow the user to bypass the login form.



I hope my description made sense. Let me know if you have any questions.

Thanks!!

[ranman256]

The form can't close without the correct password.
cancel will Run docmd.Quit to exit access.
in event UNLOAD, if password is correct then open the next form.