That darn yellow warning bar requiring you to click ENABLE.


A common problem I see when visiting a prospective client site or providing guest lectures on Access at User Groups:

“My database always prompts me to click Enable when I open it?”

First, I am surprised many people think this is normal.  Google would be quick to walk you through fixing this.  BUT, I do get a lot of people with this issue.

This is happening because Access wants to warn you about macros and other dangerous code that could theoretically be run.  To fix this, it is simple:

  1. Open the database.
  2. Click File
  3. Click Options
  4. Click Trust Center
  5. Click Trust Center Settings
  6. Click Trusted Locations
  7. Add the database location to trusted locations.

Future openings will not warn you.  You can also do JUST the document, or totally disable warnings.  I prefer the location method.

Related Posts

Access 2016 Relationships

Short blog today, this is a great read on relationships in Access 2016: Access 2016 Relationships Thanks to Microsoft for this one!

Microsoft Access Union Query from Hell. Skill Level: Demi-God

The worst query I ever had to write which powers a master report for the database user.  Here it is.  I don't think I can make it smaller, there were too many weird rules, aggregates, and translations in it.  And we needed to pull different columns based on criteria. ...



Submit a Comment