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

From CCMDB Wiki
Jump to navigation Jump to search
Created page with "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... ::..."
 
No edit summary
 
(20 intermediate revisions by 5 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
* Click to ignore the error and open anyway.
| full =
* Click Tools menu, Macro, change security to "Low", click OK.  
: 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
}}


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)
see [[Managing Trusted Locations to enable VBA in our Microsoft Access programs]]


 
== 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 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"