[AccessD] Warnings

Hello Max,

Thanks for your quick response.
Yes, that handles num 2 + 3 on my list.
I still get the first message and I think it has to do with using a mapped
drive, as when I run the same file from the C drive, I do not get that
message. Anyone confirm this?

I also still get the two messages when automating/performing the merge. 
Maybe I am stuck with the first as long as I use a hyperlink to open the
Word doc?
I don't ever remember getting the second one before (Warning. Opening this
document will run the following SQL statement:
SELECT blah blah...) Anyone?

TIA 

Bob 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Saturday, June 06, 2009 12:07 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Warnings

Bob, from memory you have to go to Tools/Macros/Security and set the lowest
selection.

It is around there somewhere if I am not exactly right about where it is.

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood
Sent: 06 June 2009 19:57
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Warnings

Hello to the list,
I just had to setup a new computer for myself.
When starting to do some work on a client's mdb, I noticed I was receiving
what I thought was a lot of "Warnings". See list below.
This is Access 2003 and involves a merge to Word via a hyperlink. This is
Vista and the mdb is on a mapped drive.

It has been awhile since I have worked on this and I cannot remember getting
all these messages.
Has someone organized solutions for avoiding some or all of the warnings?
TIA

Best,
Bob


1.
Open file - Security Warning

Do you want to open this file?

2.	
Microsoft Office Access
Security Warning: Unsafe Expressions are not blocked Do you want to block..

3.	
Security Warning
Opening Q:\Folder\FileName.mdb
This file may not be safe if it contains code that was intended to harm your
computer.
Do you want to open..

Word merge
1.
Microsoft Office Access
Opening "FileName".doc
Hyperlinks can be harmful to your computer and data

2.
Microsoft Office Access
Opening this document will run the following SQL statement:
SELECT blah blah...