Join Alicia Katz Pollock for an in-depth discussion in this video Enabling Trusted Documents, part of Access 2010 New Features.
Every time you open an Access database you have to go through a security check…since databases and macros are potential security threats.…But instead of enabling the content every single time you open the file you can…now establish the file as a trusted document and skip that step in the future.…When you open up an Access file you'll see a yellow security warning across the…top, asking if you want to enable all the content.…Click the button one time and you won't have to do it again.…If you're on a network you may get an extra dialog box explaining that others on…the network may be able to "tamper" with the file.…
Just click Yes to that message.…If you need your database to not be trusted, you can always go back to the File…tab and go down to the Options and down at the bottom of the list you'll see…Trust Center, and we can go into the Trust Center Settings.…You can specify Trusted Publishers, Trusted Locations, Trusted Documents.…This Trusted Documents will allow you to clear all the trusted documents…
- Working with Application Parts
- Implementing the Table Tools ribbon
- Using Quick Start and calculated fields
- Designing with Layout View formatting tools
- Taking advantage of enhancements to the Conditional Formatting feature
- Automating with macros
- Working with external data
- Integrating SharePoint publishing
Skill Level Intermediate
Q: My macro isn't running correctly. I followed along with the author and I'm not receiving an error message, but the actions are performed correctly.
A: There are several possible reasons why a macro would malfunction. Make sure that the macro is written correctly. Capitalization and punctuation matters. Also make sure to click in all the same places when recording the macro. With enough practice, building macros will become more routine, and spotting errors will becoming easier.