Overriding " Enable Marcos"

[Witchcraftz]

I have a database with confidential data (to be used internally only). I do not want a person opening the database to get access to the tables or other elements.

All of the security setting on all computers are set to disable macros. So anyone who opens the application now has access to seeing the table eve though I have set all the ribbons, right click, etc so no user can get to them.

Is there a way to override the security alert so I can show it in a popup prior to load?

 

[Witchcraftz]

From the lack of responses I'm guessing that this isn't possible.

Since I must do this I will figure something out.

 

[Frothingslosh]

If macros are disabled on the users' PCs, there's not much you can do. That setting prevents both macros and VBA from executing, and you need both to do what you're requesting.

Edit: I just thought of this - what about a company-wide signed certificate? That could work.

 

[TimW]

Hi
Even if macro's are selected there is always a way to hack into an Access Database. You can right click on a ribbon and alter the settings in an around about sort of way. Also, users must also have access to the tables for the database to work. I guess malicious users will be able to find the table. However, your IT department should ensure your network is secure and not open to anyone, surely?
In my work, the macros have to be enabled for the database to work. So most users have the setting changed to have them on all the time - or select run to be able to run the database.
HTH