Re: download file from within Access

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rick (anonymous_at_discussions.microsoft.com)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 08:52:17 -0800

Paul,

It works fine pasting the address into the browser or when
clients click the link in my e-mail. I and (my clients)
get the Open, Save, Cancel dialog like you do. It's just
when the link is called from within an access db. (I tried
it in another db to make sure it wasn't caused by a
conflict of trying to download a db from a db with the
same same.) From the db it bypasses that dialog and goes
straight to open the db. Could it be an Access 2000
problem?

Thanks for your responses.

Rick

>-----Original Message-----
>On Windows 2000 SP4 running Access 2003 SP1, I get a
dialog with Open, Save,
>Cancel, More Info. Your IT guys might have a group
policy set that prevents
>downloads.
>
>--
>Paul Overway
>Logico Solutions
>http://www.logico-solutions.com
>
>
>"Rick" <anonymous@discussions.microsoft.com> wrote in
message
>news:084b01c503c9$4c0edf00$a401280a@phx.gbl...
>> I'm running Access 2000 with SP3 and Windows 2000 w/
SP4.
>> Our IT guy thinks it has something to do with Office or
>> Access security measures added with SP 2 maybe? They
>> thought someone may have a workaround.
>>
>> Rick
>>
>>>-----Original Message-----
>>>Thats odd...I get the warning, but it provides options
to
>> Run, Save, or
>>>Cancel. Which OS and what SPs do you have installed?
>> What version Access
>>>and what SPs installed? If Access 2003, what is macro
>> security level set
>>>at? I'm working with Windows XP SP2, Access 2003
>> SP1....macro security low.
>>>
>>>My earlier thoughts about running a IExpress package in
>> quiet mode would not
>>>work...you'd have to let it prompt them to start after
>> your app closes.
>>>
>>>--
>>>Paul Overway
>>>Logico Solutions
>>>http://www.logico-solutions.com
>>>
>>>
>>><anonymous@discussions.microsoft.com> wrote in message
>>>news:203601c5032f$79725750$a501280a@phx.gbl...
>>>> Paul, I get the same problem with the FollowHyperlink,
>>>> After the login screen it does not go to the Open or
>> Save
>>>> screen but straight to the warning about opening
files.
>>>> i.e. it doesn't give you a chance to Save the file to
a
>>>> disk.
>>>>
>>>> Any other thoughts?
>>>>
>>>> Rick
>>>>>-----Original Message-----
>>>>>Use FollowHyperlink within the click event for your
>>>> button.
>>>>>
>>>>>Yes...the files need to be closed before they can be
>>>> overwritten. An
>>>>>IExpress installer package may have some utility in
this
>>>> situation.
>>>>>Basically, you'd start the download, Shell to run the
>>>> IExpress package to
>>>>>update your app (in quiet mode), quit Access, then
>> within
>>>> the IExpress
>>>>>package launch your app again as a post install
command.
>>>> See white paper at
>>>>>site below for more info on IExpress.
>>>>>
>>>>>--
>>>>>Paul Overway
>>>>>Logico Solutions
>>>>>http://www.logico-solutions.com
>>>>>
>>>>>
>>>>>"Rick" <anonymous@discussions.microsoft.com> wrote in
>>>> message
>>>>>news:01fb01c50323$d0cbe810$a401280a@phx.gbl...
>>>>>> My clients have a runtime app. It is a front-end db
>>>> linked
>>>>>> to a back-end db. I send them e-mails with a link to
>> our
>>>>>> website that starts a download procedure to update
the
>>>>>> files, one or the other. I'd like to include the
links
>>>> in
>>>>>> the app. I've set the Hyperlink.Address for a
command
>>>>>> button and it will bring up the login screen but
after
>>>>>> logging in it goes straight to the open file warning
>>>>>> instead of the save or open file screen like it does
>> if
>>>>>> they enter the address into their browser or click
on
>>>> the
>>>>>> link in the e-mail. Is Access causing this and is
>> there
>>>> a
>>>>>> workaround?
>>>>>>
>>>>>> Also, I think the app. will need to close before the
>>>> file
>>>>>> can be saved into the same folder, right? I tried
>>>>>> Docmd.Quit on click of the command button but that
>>>>>> crashed. How could I initiate the download AND close
>> the
>>>>>> program?
>>>>>>
>>>>>> Thanks.
>>>>>>
>>>>>> Rick
>>>>>
>>>>>
>>>>>.
>>>>>
>>>
>>>
>>>.
>>>
>
>
>.
>

Quantcast