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
 
(15 intermediate revisions by 4 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
* click on '''trust center''' (bottom of left panel)
| full =  
* click '''Trust center options''' button (bottom right)
: A potential security concern has been identified
* click '''Trusted locations'''
: This location may be unsafe
* make sure checkbox for '''Allow trusted locations on my network''' is '''checked''' (in the bottom of window)
: <a file path>
* make sure there is a line with "\\ad.wrha.mb.ca\wrha\REGION\Shared\ICU_DATA_COLLECTION\", and subfolders checked, add if not.
: 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
}}


== In Access 2003 ==
== Steps to prevent this from coming up ==
''Access 2003 is installed on PCs set up in the past, for any newly set up ones use instructions [[#In Access 2010]].''
see [[Managing Trusted Locations to enable VBA in our Microsoft Access programs]]
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:
== Related articles ==
* set menus to always show all (Tools, Customize, Always show full menus)
{{Related Articles}}
 
 
[[Category: Laptop]]
[[Category: IT Instructions]]
[[Category: New Hire]]

Latest revision as of 10:56, 10 November 2025

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

see Managing Trusted Locations to enable VBA in our Microsoft Access programs

Related articles

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