programmatically unblock downloaded files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan - 26 Jul 2007 11:28 GMT

How does one programmatically unblock a downloaded file with access?

Background:
My FE database needs to search through Microsoft Outlook for the latest
email containing the BE. Save it. Unblock it. Rename it. ReLink to it.

I think I have all steps sorted out now. I am just stuck on the Unblocking.

Reply to this Message

Ralph - 26 Jul 2007 19:48 GMT

Not sure I understand the question, but I will assume you mean the attachment
is blocked by Outlook? If that is the case try the link below:

http://www.slovaktech.com/attachmentoptions.htm

> How does one programmatically unblock a downloaded file with access?
>
[quoted text clipped - 3 lines]
>
> I think I have all steps sorted out now. I am just stuck on the Unblocking.

Reply to this Message

Jonathan - 26 Jul 2007 21:52 GMT

Thanx for your reply.
No. I don't have an Outlook problem. My way around that is to rename the
database file before emailing so that it has a txt extention instead of a mdb
extention.

Windows XP SP2 and Windows Vista, by default blocks all files, even txt
files. You have to manually right click the file go to properties, then click
the unblock button.

> Not sure I understand the question, but I will assume you mean the attachment
> is blocked by Outlook? If that is the case try the link below:
[quoted text clipped - 8 lines]
> >
> > I think I have all steps sorted out now. I am just stuck on the Unblocking.

Reply to this Message

Ralph - 26 Jul 2007 22:00 GMT

So is it blocked in Outlook? I run Windows XP SP2 and don't have that problem
with txt files. Outlook 2003 blocks mdb files along with a number of other
extensions.

> Thanx for your reply.
> No. I don't have an Outlook problem. My way around that is to rename the
[quoted text clipped - 17 lines]
> > >
> > > I think I have all steps sorted out now. I am just stuck on the Unblocking.

Reply to this Message

Jonathan - 26 Jul 2007 23:42 GMT

It's funny, not all Windows xp sp2 computers behave the same.
The majority do seem to block files. This doesn't just apply to attachments.
When you download a file using Internet Explorer again the file gets blocked
until you right click it.
Go to properties, then click the unblock button.

> So is it blocked in Outlook? I run Windows XP SP2 and don't have that problem
> with txt files. Outlook 2003 blocks mdb files along with a number of other
[quoted text clipped - 21 lines]
> > > >
> > > > I think I have all steps sorted out now. I am just stuck on the Unblocking.

Reply to this Message

John Nurick - 27 Jul 2007 06:21 GMT

I've never encountered this in XP and wonder if it's third-party
antivirus/security software that's blocking the files. Or maybe it's a
new security feature in Vista.

Either way, there wouldn't seem to be much point in such a feature if
it could be overridden by any old application, so I guess that it will
be necessary to log in as administrator and change the settings (e.g.
so that files of that type are not blocked).

>It's funny, not all Windows xp sp2 computers behave the same.
>The majority do seem to block files. This doesn't just apply to attachments.
[quoted text clipped - 27 lines]
>> > > >
>> > > > I think I have all steps sorted out now. I am just stuck on the Unblocking.

--
John Nurick - Access MVP

Reply to this Message