From the course: Access 2019: Macros

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Macros and security

Macros and security

From the course: Access 2019: Macros

Start my 1-month free trial

Macros and security

- When creating a new macro in the design window, you might have noticed that we have this button on the ribbon that says show all actions. If you click on it, it doesn't look like anything has happened here in the interface. But, if you start to drill in to some of the actions inside of the action catalog, you'll start to see that we have a lot of new actions that we can choose from. And they all share this yellow triangle icon. All of these actions with the yellow icon will only function in a trusted database. That means that if a user has not explicitly allowed block content to run, these macro actions will fail to run as intended. Users can trust a database by saving it into a folder in their list of trusted locations, or by clicking on the enable content button on the yellow security warning bar that appears when the database is first opened. The reason that these actions will only run in a trusted database is because they can all either modify the structure of the database or…

Contents