Understanding How Databases Behave When Trusted and Untrusted

Unless a database has a digital signature or is located in a trusted location, Access disables several features. The following is a list of differences between a trusted and untrusted database:

  • All VBA code is disabled.
  • All unsafe expressions (certain formulas and functions in the database) are disabled.
  • Unsafe actions in all macros are disabled. Unsafe actions include any functionality that could potentially modify the database or gain access to resources outside the database.
  • Action queries, data definition language (DDL) queries, and SQL pass-through queries are all disabled.
  • All ActiveX controls are disabled.

Get Microsoft now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.