Changing settings in MS Access after first open: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 6: | Line 6: | ||
To stop those errors from happening every time you open [[CCMDB.mdb]], and to prevent malfunction, do the following: | To stop those errors from happening every time you open [[CCMDB.mdb]], and to prevent malfunction, do the following: | ||
* Open CCMDB.mdb | * Open CCMDB.mdb | ||
* The following message appears ... | |||
** Security Warning: Unsafe expressions are not blocked. | ** Security Warning: Unsafe expressions are not blocked. | ||
** Do you want to block unsafe expressions? | ** Do you want to block unsafe expressions? | ||
* Click "No" to ignore the error and open | * 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. | |||
* Clock the "Open" button to continue. | |||
* Click Tools menu, Macro, change security to "Low", click OK. | * Click Tools menu, Macro, change security to "Low", click OK. | ||
Revision as of 09:50, 2013 May 31
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...
- if someone could enter the actual error here that would be great...
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.
- Clock 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)
In Access 2010
- see http://www.ageesw.com/macro.htm for instructions for this in Access 2010