Changing settings in MS Access after first open

From CCMDB Wiki
Revision as of 10:23, 2014 July 3 by Ttenbergen (talk | contribs) (headers for Access 2010 vs 2003)
Jump to navigation Jump to search

Whenever a user first uses a laptop they have not used before, Access will give them an error upon opening the database.

the error says something about security etc...
if someone could enter the actual error here that would be great...

In Access 2003

Access 2003 is installed on PCs set up in the past, for any newly set up ones use instructions #In Access 2010. To stop those errors from happening every time you open CCMDB.mdb, and to prevent malfunction, do the following:

  • Open CCMDB.mdb
  • The following message appears ...
    • Security Warning: Unsafe expressions are not blocked.
    • Do you want to block unsafe expressions?
  • Click "No" to ignore the error and continue anyway.
  • The following message appears ...
    • Security Warning:
    • This file may not be safe IF it contains code that was intended to harm your computer.
    • Do you want to open this file or cancel the operation.
  • Click the "Open" button to continue.
  • Click Tools menu, Macro, change security to "Low", click OK.

While in here, for consistency, also:

  • set menus to always show all (Tools, Customize, Always show full menus)


In Access 2010