Home All Groups Group Topic Archive Search About
Author
18 Oct 2005 6:05 PM
Tuk
Access gives me a macro security warning when I use a database developed in
Office 2002.  It will ask me if i want to proceed with opening the database
and then give me macro errors throughout the database as i access different
pages and wont let me edit some of my values.  It also prevents me from
saving anything into the database.  How can I get this to work with Office
2003?  It works great in Office 2002.

Author
18 Oct 2005 6:17 PM
Rick Brandt
Tuk wrote:
> Access gives me a macro security warning when I use a database
> developed in Office 2002.  It will ask me if i want to proceed with
> opening the database and then give me macro errors throughout the
> database as i access different pages and wont let me edit some of my
> values.  It also prevents me from saving anything into the database.
> How can I get this to work with Office 2003?  It works great in
> Office 2002.

Those warnings occur with ANY file opened with Access 2003 (it's a feature)
unless you set macro security to low.

Tools - Macro - Security


--
I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com
Author
19 Oct 2005 5:31 AM
TC
/DO NOT/ set macro security to Low, until you have investigated the
AutomationSecurity property. For more information, google this group
for posts from me (TC) containing that word.

HTH,
TC