Microsoft Office Tutorials and References
In Depth Information
Opening Databases That Contain Macros
Do you want
6. Browse to the folder where you plan to store your Access databases,
and click OK.
If you might store databases in subfolders, too, click the Subfolders
of This Location Are Also Trusted check box. You return to the Trust
Center dialog box, whether you can modify and remove folders from the
list of trusted locations.
7. Click OK to return to the Access Options dialog box.
8. Click OK in the Access Options dialog box to return to your database.
Now when you open databases in the specified folder, Access won’t
display any alarming messages, or disable macros or VBA code in the
Signing your database
Another way to turn off Access’s security measures is to sign your
databases. Signing a database for your own use is easy: You create your own
digital signature and then use it to sign your databases. This signature works
only on your own computer: When other people open your database, they
still see the security warning message. If you want to create a digital
signature that works everywhere, you need to contact a certification authority
and buy one.
Follow these steps to create a digital signature for use on your own computer:
1. Depending on your operating system, do one of the following:
• InWindows7,chooseStart ➪ All Programs ➪ Microsoft Office ➪
Microsoft Office 2013 Tools ➪ Digital Certificate for VBA Projects.
Windows System 7 may prompt you to install this program unless
you’ve used it before. If so, follow its prompts. You see the dialog box
shown in Figure 1-9.