Need code to download access database

[bradmaunsell]

I am new to ASP and web sites. I have created a web app on my laptop under

http://wwwroot

and it works fine. I want to put this on a hosted site something like bCentral.

My question is how do I download the access database from the web site to our local server.

I have been working with this piece of code but keep getting a page not found error.

<% Response.Redirect &quot;Web12Tables.mdb&quot; %>

Front Page 2000
Access 97 database (about 4MB)
5 tables in database

Can anybody offer some code to download my databse?

Thanks,
Brad
South Burlington, Vermont

 

[krisbrixon]

Unless I am not understanding what you want, you can download it from the same place you uploaded it.

or

<a href=&quot;Web12Tables.mdb&quot;>database</a>

Kris

 

[bradmaunsell]

Thanks Kris. I just figured it out and I should have known the answer. My problem was not including the full path to the database.

However, now I would like to ask if the download process can initiated at the hosted web site.

In other words, is there a way for to send/download the database from the hosted web site to our local server at 3:00 every afternoon?

Brad

 

[Tarwn]

This would require an application to run, if you depend on a web page doing it, then someone will have to access that page every day at 3:00 (and never at any other time). You could prbably create a small application in vb to get the file from the given address and save it locally, than run that app on the local server as a scheduled task for 3:00 every day.

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)

 

[SerialCoder]

A point of Warning. if you use FrontPage and it has created a FPDB folder in the root of the site that your Access file is in, you wont get it to download. part of the Frontpage Extension feaures in IIS protect that database from download. It a cool feature but would prohibit you from doing what you want.

 

[bradmaunsell]

Hmmm... Does that apply to only the FPDB direstory? If I place the database outside of FPDB, will I be able to download it? If so, are trade-offs? I need to download load several times a day during the busy season.

Let me add another thing. The web site is avaialable to a select group of 1,300 of our customers. ALthough I have not coded this function yet, no customer can be allowed to see another customer's data. The tables include names and addresses foe each customer and the stores they own. The customer maintains their own info. In addition, there are 5 rpoduct line order forms. The complete database gets downloaded for order rpocessing. Note the name and address are important to download as the billing address could change or a retail store could be added.

Thanks again for the advise,
Brad