What is the best way to protect an access database so that people can type in the location to the database and start downloading it? Is their a chmod setting that would do it but still allow read access and write permissions?

thanks

Keith Slater

you'd have to put it outside of the webroot... so that it wouldn't be accesible through HTTP, then the FTP site would be set to be one directory up... like this:

legend
[f] folder
[] file
--------------------
<b>[f]</b>ftproot
<b>|--[f]</b>webroot
<b>|--|--</b>[]index.asp
<b>|--|--</b>[]something.asp
<b>|--</b>[]database.mdb
-----------------------

so as you can see, only things in the webroot can be seen from a browser, but your connection string would be set up to go up a directory to look for the database...

hope that was a good explanation

Joel Martinez

----------
set rs = conn.execute("SELECT answer FROM brain WHERE question = "& forumPost &"