Need to disable 2007 security

[Guest]

Hello everyone,

I created a custom Access DB with reports that includes VB coding to
condition some text. In 2003 I would get an error (2447) when Macro Security
wasn't set to "low".

Recently I upgraded to 2007 and tried to get the security low enough to not
get this same error, but all attempts have failed.

I have the file in a "Trusted Location" and disabled Macro Security. Yet, I
still get the error. How do I disable the security far enough to have my MDB
run without errors (yes it is in 2003 format). I wrote the code myself so I
know for sure it is trusted.

Thank you in advance.

 

[Scott McDaniel]

Hello everyone,

I created a custom Access DB with reports that includes VB coding to
condition some text. In 2003 I would get an error (2447) when Macro Security
wasn't set to "low".

Error 2447 is

Invalid use of the . (dot) or ! operator or invalid parenthesis

Is that correct, or are you referring to another error?

Recently I upgraded to 2007 and tried to get the security low enough to not
get this same error, but all attempts have failed.

I have the file in a "Trusted Location" and disabled Macro Security. Yet, I
still get the error. How do I disable the security far enough to have my MDB
run without errors (yes it is in 2003 format). I wrote the code myself so I
know for sure it is trusted.

This link might help:

http://office.microsoft.com/en-us/access/HA012301871033.aspx

Thank you in advance.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com