Changing settings in MS Access after first open

From CCMDB Wiki
Revision as of 12:56, 2015 April 8 by Ttenbergen (talk | contribs) (proper instructions, the ones we linked to before were wrong.)
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 2010

  • click on file (top right corner), options
  • click on trust center (bottom of left panel)
  • click Trust center options 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 there is a line with "\\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\", and subfolders checked, add if not.

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)