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

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
Grondeau (talk | contribs)
16 edits
No edit summary
No edit summary
 
(16 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.  


To stop those errors from happening every time you open [[CCMDB.mdb]], and to prevent malfunction, do the following:
{{Collapsable
* Open CCMDB.mdb
| always = old error
* The following message appears ...
| full =
** Security Warning: Unsafe expressions are not blocked.
: A potential security concern has been identified
** Do you want to block unsafe expressions?
: This location may be unsafe
* Click "No" to ignore the error and continue anyway.
: <a file path>
* The following message appears ...
: Hyperlinks can be hearmful to your computer and data. To protect your computer, click only on those hyperlinks from trusted sources.  
** Security Warning:  
:
** This file may not be safe IF it contains code that was intended to harm your computer.
: Do you want to continue?
** Do you want to open this file or cancel the operation.
:  Yes button / No button
* Click the "Open" button to continue.
}}
* Click Tools menu, Macro, change security to "Low", click OK.


While in here, for consistency, also:  
== Steps to prevent this from coming up ==
* set menus to always show all (Tools, Customize, Always show full menus)
* 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 ==  
== In Access 2010 ==
{{Related Articles}}
* see http://www.ageesw.com/macro.htm for instructions for this in Access 2010
 
 
[[Category: Laptop]]
[[Category: IT Instructions]]
[[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"