Vba code to remove accde security warning

[erickemboi]

I converted my database to accde but whenever I open I get a nagging security warning. I intend to deploy the database to be used by several clients. Is there a function or vba code to remove this warning? The function should be put in database so that the clients will not be faced with this nagging message. Thanks in advance.

[CJ_London]

Catch 22 - code won’t run until warning is accepted

Solution is to put the accde in a trusted location

How do you ensure your client does this? You don’t just send them the front end, you send an installer to install the app which would create trusted location and place the app there.

Trusted locations are set in the registry so you also need to make sure your client has admin rights to modify it for the installer to work.

[Emmanuel]

Go to the options settings in the database.
Select trust settings.
Select trust center settings
Select macro settings and
Select enable all macros.

If issue still persists,
Select activex settings and
Select enable all controls

Each of these actions may require you to restart your database.

This should fix your issue

[isladogs]

The warning is related to trusted locations as Ajax stated. Changing the macro and/or activeX settings will allow or prevent certain types of code/controls working but won't prevent the security warning.