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

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m proper instructions, the ones we linked to before were wrong.
No edit summary
 
(14 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Whenever a user first uses a laptop they have not used before, Access will give them an error upon opening the database.  
eHealth has us in a policy that should prevent the following. If anyone gets this error please let me know so we can fix the underlying problem instead of repeated manual fixes.  
{{fixed bug}}


:: the error says something about security etc...
A yellow bar at the top of the screen that says  
:: if someone could enter the actual error here that would be great...  
: '''Security Warning'''  Some active content has been disabled. Click for more details.  


== In Access 2010 ==
{{Collapsable
* click on '''file''' (top right corner), '''options'''
| always = old error
| full =
: A potential security concern has been identified
: This location may be unsafe
: <a file path>
: Hyperlinks can be hearmful to your computer and data. To protect your computer, click only on those hyperlinks from trusted sources.
:
: Do you want to continue?
:  Yes button / No button
}}
 
== Steps to prevent this from coming up ==
* click on '''file''' (top left corner), '''options'''
* '''If this error is preventing you from accessing the options menu, close the program. Open Access from the start menu, and instead of opening the database, open a new blank database. You should then be able to access file and options.'''
* click on '''trust center''' (bottom of left panel)
* click on '''trust center''' (bottom of left panel)
* click '''Trust center options''' button (bottom right)
* click '''Trust center Settings''' button (bottom right)
* click '''Trusted locations'''
* click '''Trusted locations'''
* make sure checkbox for '''Allow trusted locations on my network''' is '''checked''' (in the bottom of window)
* 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.
* make sure the following lines exist:
 
** "\\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\", and subfolders box is checked.
== In Access 2003 ==
** "C:\" and subfolders box is checked.
''Access 2003 is installed on PCs set up in the past, for any newly set up ones use instructions [[#In Access 2010]].''
** if using (e.g. [[White Board]]) , "\\ad.wrha.mb.ca\wrha\HSC\shared\MED\MED_CCMED\" , and subfolders box is checked S:\MED\MED_CCMED
To stop those errors from happening every time you open [[CCMDB.mdb]], and to prevent malfunction, do the following:
** add new location if needed:
* Open CCMDB.mdb
* click on '''Add New Location'''
* The following message appears ...
* copy/paste the location from above
** Security Warning: Unsafe expressions are not blocked.
* '''make sure you check off checkbox "subfolders of this location are also trusted"
** 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)
 


[[Category: Laptop]]
== Related articles ==
[[Category: IT Instructions]]
{{Related Articles}}
[[Category: New Hire]]

Latest revision as of 06:44, 2023 October 31

eHealth has us in a policy that should prevent the following. If anyone gets this error please let me know so we can fix the underlying problem instead of repeated manual fixes.


A yellow bar at the top of the screen that says

Security Warning Some active content has been disabled. Click for more details.
old error   
A potential security concern has been identified
This location may be unsafe
<a file path>
Hyperlinks can be hearmful to your computer and data. To protect your computer, click only on those hyperlinks from trusted sources.
Do you want to continue?
Yes button / No button

Steps to prevent this from coming up

  • click on file (top left corner), options
  • If this error is preventing you from accessing the options menu, close the program. Open Access from the start menu, and instead of opening the database, open a new blank database. You should then be able to access file and options.
  • click on trust center (bottom of left panel)
  • click Trust center Settings 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 the following lines exist:
    • "\\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\", and subfolders box is checked.
    • "C:\" and subfolders box is checked.
    • if using (e.g. White Board) , "\\ad.wrha.mb.ca\wrha\HSC\shared\MED\MED_CCMED\" , and subfolders box is checked S:\MED\MED_CCMED
    • add new location if needed:
  • click on Add New Location
  • copy/paste the location from above
  • make sure you check off checkbox "subfolders of this location are also trusted"

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Changing_settings_in_MS_Access_after_first_open&oldid=160333"