– The “C:\Database\” is the physical path that you want to set to be as Trusted Location. But if you want to make more than one path as trusted location, then each location must end up with different number. Other programs include default MS Access wizards, already have used other numbers. 20 can be any number that is not previously used. – The “Location20” is a unique name that you assign. You can change the numbers that represent the version you are executing. – The number “14.0” is the version of MS Office. See method #2 or #3 in this blog: Īnd in case the blogs ever gets removed, here is the important bits: What's nice about this method is that you can easily automate this to happen on the computers where you deploy your app. You can create a registry key that will add the directory as a trusted location and will not show the warning anymore. If you're using a more recent version, the instructions may vary somewhat. Note - I wrote the above for our company based on Office 2003.
Have this, you will need to contact your IT Dept.)Įnter a Certificate Name. Office Tools -> Digital Certificate For VBA Projects (If you don’t To do this, you will need to perform the following tasks:Ĭlick on Start -> All Programs -> Microsoft Office -> Microsoft Digital Certificates are good only on the computer they are created on, so if this database will be used on multiple computers then each one will have to create a Digital Certificate.
In order to get around this issue, you will need to create a Digital Certificate. You have to set their computer to be a trusted source.
0 kommentar(er)
