Wednesday, May 27, 2020

Stop disabled mode from blocking a query

If you try to run a query in Access and it does not work, the query might be blocked because Access is in disabled mode. Disabled mode is a reduced functionality mode that occurs when Access cannot determine whether the content in the database is trusted.

To make the query work, you must enable the database content by indicating that you trust the database content. You can enable database content for a session or specify that a given database is trustworthy and should be enabled by default. For a full discussion on how to trust a database, see the article Decide whether to trust a database. Once you trust a database, Access won't block the query from running.

Note: You can also signify that a database is trustworthy by using a digital signature. For more information about digital signatures, see Show trust by adding a digital signature.

No comments:

Post a Comment