download file from within Access

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

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
 
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, 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
 
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.
 
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
 
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,

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
 
Back
Top