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

(17 intermediate revisions by 4 users not shown)

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.

:: 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)~~

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

== Related articles ==

== ~~In Access 2010~~ ==

* see http://www.ageesw.com/macro.htm for instructions for this in Access 2010

~~[[Category: Laptop]]~~

~~[[Category: IT Instructions]]~~

~~[[Category: New Hire]]~~

@@ 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)
+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]]