How to Enable Macros in Microsoft Access Databases
You may notice that your macros and some of your code are not running. By default Microsoft Access blocks macros and some VBA code from running to help protect your database. Normally you will want to allow your code and macros to run without any blocking action. Follow the steps below to unblock your macros and code.
Click File in the upper left.
Then click Options
Then click Trust Center, and then click Trust Center Settings
Click Macro Settings and then set to Enable all macros, then click Ok on all screens until they all close