|  | Security settings cannot be changed | | |
| | | TJAC |  |
|  Posted: Thu Sep 11, 2008 12:31 pm Post subject: Security settings cannot be changed |  |
I have a computer with Access 2002 and every time you open a database it
comes up with the security warning. However, when I go to Macros to select
Security, security is grayed out. I have never seen this before. This
computer does have Visual Basic on it, wouldn't think that matters, but my
others do not.
How can I change that security setting or get that so it is accessible to
set the security settings and no longer receive that message.
Thanks! |
| |
| | | Chris O'C via AccessMonst | |
| | Posted: Thu Sep 11, 2008 12:48 pm Post subject: Re: Security settings cannot be changed | |
Access 2002 doesn't have macro security so you can't set it to low. That
requires Access 2003 or 2007.
Please post the security warning message.
Chris
Microsoft MVP
TJAC wrote:
| Quote: | I have a computer with Access 2002 and every time you open a database it
comes up with the security warning. However, when I go to Macros to select
Security, security is grayed out. I have never seen this before. This
computer does have Visual Basic on it, wouldn't think that matters, but my
others do not.
How can I change that security setting or get that so it is accessible to
set the security settings and no longer receive that message.
|
--
Message posted via AccessMonster.com
LINK |
| |
| | | TJAC | |
| | Posted: Thu Sep 11, 2008 1:03 pm Post subject: Re: Security settings cannot be changed | |
| |  | |
Sorry, you're right, it's 2003.
The security warning says Security Warning in the top of the message box and
tells you that opening (path and name of database)
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.
Button choices are Cancel Open or More Info.
You can set the Macro Security settings to low and not receive this anymore,
which is what we want so that every database doesn't give this message.
Databases are blocked in our email so we are not concerned about that.
Thanks!
"Chris O'C via AccessMonster.com" wrote:
| Quote: | Access 2002 doesn't have macro security so you can't set it to low. That
requires Access 2003 or 2007.
Please post the security warning message.
Chris
Microsoft MVP
TJAC wrote:
I have a computer with Access 2002 and every time you open a database it
comes up with the security warning. However, when I go to Macros to select
Security, security is grayed out. I have never seen this before. This
computer does have Visual Basic on it, wouldn't think that matters, but my
others do not.
How can I change that security setting or get that so it is accessible to
set the security settings and no longer receive that message.
--
Message posted via AccessMonster.com
LINK
|
|
| |
| | | Chris O'C via AccessMonst | |
| | Posted: Thu Sep 11, 2008 1:32 pm Post subject: Re: Security settings cannot be changed | |
| | | |
Your macro security is set to the default, medium. To change it, open Access
(without opening a db file). Click on Tools > macro. Is security still
grayed out?
If it's not, click on security and click on low. When
the dialog closes, the next message pops up "Unsafe expressions are blocked...
Do you want to allow the evaluation of potentially unsafe expressions?"
Click on the "Yes" button.
If it's grayed out it means your admins won't let users change the setting in
the registry.
If you trust the person who sent you the db, have them digitally sign the db
or if the db doesn't have user level security, you could open the db with an
automation security vb script to avoid the security warnings. Scan the db
file with an antivirus scanner before you open the db the first time.
Chris
Microsoft MVP
TJAC wrote:
| Quote: | Sorry, you're right, it's 2003.
The security warning says Security Warning in the top of the message box and
tells you that opening (path and name of database)
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.
Button choices are Cancel Open or More Info.
You can set the Macro Security settings to low and not receive this anymore,
which is what we want so that every database doesn't give this message.
Databases are blocked in our email so we are not concerned about that.
|
--
Message posted via AccessMonster.com
LINK |
| |
| | | Jacob Burke | |
| | Posted: Fri Sep 12, 2008 11:16 pm Post subject: Re: Security settings cannot be changed | |
what
"Chris O'C via AccessMonster.com" <u29189@uwe> wrote in message
news:8a097a07c00c4@uwe...
| Quote: | Access 2002 doesn't have macro security so you can't set it to low. That
requires Access 2003 or 2007.
Please post the security warning message.
Chris
Microsoft MVP
TJAC wrote:
I have a computer with Access 2002 and every time you open a database it
comes up with the security warning. However, when I go to Macros to
select
Security, security is grayed out. I have never seen this before. This
computer does have Visual Basic on it, wouldn't think that matters, but my
others do not.
How can I change that security setting or get that so it is accessible to
set the security settings and no longer receive that message.
--
Message posted via AccessMonster.com
LINK
|
|
| |
| | | jay | |
| | Posted: Sat Sep 13, 2008 1:12 am Post subject: Re: Security settings cannot be changed | |
| | | |
I don't know!
"Chris O'C via AccessMonster.com" <u29189@uwe> дÈëÏûÏ¢ÐÂÎÅ:8a09dd5bb3905@uwe...
| Quote: | Your macro security is set to the default, medium. To change it, open
Access
(without opening a db file). Click on Tools > macro. Is security still
grayed out?
If it's not, click on security and click on low. When
the dialog closes, the next message pops up "Unsafe expressions are
blocked...
Do you want to allow the evaluation of potentially unsafe expressions?"
Click on the "Yes" button.
If it's grayed out it means your admins won't let users change the setting
in
the registry.
If you trust the person who sent you the db, have them digitally sign the
db
or if the db doesn't have user level security, you could open the db with
an
automation security vb script to avoid the security warnings. Scan the db
file with an antivirus scanner before you open the db the first time.
Chris
Microsoft MVP
TJAC wrote:
Sorry, you're right, it's 2003.
The security warning says Security Warning in the top of the message box
and
tells you that opening (path and name of database)
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.
Button choices are Cancel Open or More Info.
You can set the Macro Security settings to low and not receive this
anymore,
which is what we want so that every database doesn't give this message.
Databases are blocked in our email so we are not concerned about that.
--
Message posted via AccessMonster.com
LINK
|
|
| |
|
|
