Changing settings in MS Access after first open: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m headers for Access 2010 vs 2003
m proper instructions, the ones we linked to before were wrong.
Line 3: Line 3:
:: the error says something about security etc...
:: the error says something about security etc...
:: if someone could enter the actual error here that would be great...  
:: 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 ==
== In Access 2003 ==
Line 21: Line 29:
While in here, for consistency, also:  
While in here, for consistency, also:  
* set menus to always show all (Tools, Customize, Always show full menus)
* set menus to always show all (Tools, Customize, Always show full menus)
== In Access 2010 ==
* see http://www.ageesw.com/macro.htm for instructions for this in Access 2010





Revision as of 12:56, 2015 April 8

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)