disable security warning

[chungtinhlak]

is there a way to get rid of this security warning when we open using vba.

Image Removed due to privacy concerns.
~Oorang

[Oorang]

Yes. You will sign the Database's project. Then install the certificate on the users computer and finally have them trust the certificate. Here is how.
1.) First open up SelfCert. You may not have a shortcut to this program, if not it's generally here: C:\Program Files\Microsoft Office\OFFICE11\SELFCERT.EXE
2.) You will be prompted to create a name for this certificate. This name should be something you will remember and want visibly associated with the Application.
3.) Click OK to create the certificate and close self cert.
4.) Open up the database in question. Press Alt-F11 to open the VBE.
5.) Under Tools>Add-Ins Click "Digital Signature".
6.) Click the "Choose" button and select the certificate you just created.
7.) Click OK and save the Database/Workbook/Etc.
8.) Now you are ready to install the certificate on the user's machine. To do this, open the database on a user's machine and you will get a different security prompt now. Click "Details" on this prompt.
9.) Click "View Certificate"
10.) Click "Install Certificate"
11.) Follow the prompts (usually the default values will be fine).
12.) After you follow the prompts the database will open as normal, close it an reopen it. This time you have an option to "Always Trust this Publisher." Checking this box will get rid of all security prompts on entry.

[OBP]

Aaron, that is a very useful response, I will bookmark this for future reference, thankyou. :beerchug:

[nepotist]

Thanks for this info.. But is there a way to also remove the certificate to the trusted list ?

[chungtinhlak]

thank you i will try this

Edit: thanks works perfectly fine.

[Oorang]

Aaron, that is a very useful response, I will bookmark this for future reference, thankyou. :beerchug:

thanks works perfectly fine.

We try :thumb


*snip* is there a way to also remove the certificate to the trusted list ?

In Access, go to Tools>Macros>Security>Trusted Publishers.
Then select the certificate in question and click "Remove".