Database Downloading

[SanTorez]

We want to allow a user of IE, to download their Access 2000.Mdb without using an Ftp program and that will require a password entry.

In my test when using an IE web browser when I enter ftp://someuser@localhost/somedb.mdb , I get a “The page can not be displayed” message.
I would like to enter the above link and after authentication, downloading should start immediately.
Instead I have to enter ftp://someuser@localhost and then double click on somedb.mdb to download the database.
My IE is version 6.0

[MikerRoo]

Why use FTP?

Why not use a normal link:
<a href=" http://YourServer/YourDir/Database.mdb">Download the DB</a>

This can be secured the same way as the rest of your web app and works with ALL browsers, not just IE.

[SanTorez]

Thank you for your suggestion, but our database is outside of the root of my website and your suggestion does not work.

[MikerRoo]

OK, here's how you handle that:

1. Create a new file, AccessDB_Server.cfm .
   Its contents are these two lines, to start:
   
   <CFHEADER name="Content-Disposition" value="inline; filename=MyDataBase.mdb">
   <CFCONTENT type="application/vnd.ms-access" file="C:\temp\UsersDB.mdb">
   
   
2. Now the link becomes:
   <a href=" http://YourServer/YourDir/AccessDB_Server.cfm">Download the DB</a>
   

BTW, this all kinds of security advantages and works with any browser.

[hatethisnamegame]

You need to have user permission set on the server for the folder the db is in