I think it's time to stop turning off the macro security thingy in the MS-Office. It seems to be more and more complicated with the newer office versions anyway. Instead, I'd like to assign a digital signature to the database application. I hope self-sign should help to get rid the security warning permanently. I suppose user can store the app certificate and won't be warned again (correct me if I'm wrong). What I'd like to know is:
1] What type of certificate I need to generate - what info should be included in the cert, what file types I need. What kind of certs is used for the apps in general - are these the same like for web servers, open-vpn, emails etc?
2] What is the simplest app for creating certificates and is there some verified on-line generators?
3] I'd like my apps to be certified forever. Can this be achieved?
4] How to assign the cert to the database app .mdb and .accdb? Does the MS ACCESS 2003 and 2007(10) handle the certs the same way?
If anyone went through this please share your experiences. And please not to many details and external links. The idea behind this question is to create a nice how-to sign a database without reading a tons of text.
Actually you can get rid of all Access security prompts in two ways.
One: set macro security = low. This is what I done for years and it works rather well.
Two: Simply ensure you add the folder where you place the database as a trusted folder location.
Doing EITHER of the above two removes all security prompts. So it is the WRONG question to worry and waste time about some digital signer when OH SO such easy OTHER options exist to remove the security prompts.
So don’t worry about digital certs etc.
Just add the folder as a trusted location and you should be ok. As noted another approach is to simply set macro security to low. Either approach removes all nag prompts and going down other roads is a big waste of time and resources.