Managing Trusted Locations to enable VBA in our Microsoft Access programs

Over time Microsoft and eHealth and Shared Health and Digital Health etc have tightened the default settings to prevent harmful macros from running. We use macros, and the following enables running them, but only for files in specific directories.

Instructions

• open one of our Microsoft Access programs
• click on file (top left corner), options
• If this error is preventing you from accessing the options menu, close the program. Open Access from the start menu, and instead of opening the database, open a new blank database. You should then be able to access file and options.
• click on trust center (bottom of left panel)
• click Trust center Settings button (bottom right)
• click Trusted locations
• make sure checkbox for Allow trusted locations on my network is checked (in the bottom of window)
• make sure the following lines exist and make sure you check off checkbox "subfolders of this location are also trusted"
  • "\\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\"
  • "C:\"
  • "\\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\PHI" - if you are part of PHI copy automation
• add new location if needed:
• click on Add New Location
• copy/paste the location from above
• make sure you check off checkbox "subfolders of this location are also trusted"