Protecting the .mdb

[DeepBlerg]

Hi,

I have a .mdb stored on the server containing contact information for various clients. If somebody knows which directory it is in they can easily just type the address in and download the database. How can I protect it from import but still make it writable from ASP files?

Thanks.

 

[codestorm]

Simple way would be to set a database password and
include it in the connection string (pwd=<password here>).
This won't stop them downloading it, but should stop most people from opening it. codestorm

 

[DeepBlerg]

Hi,

This is the vbscript I use, where would i put the connection string (pwd=<password here>)?

Set dbconnection = Server.CreateObject(&quot;ADODB.Connection&quot
dbconnection.open &quot;DSN=clients&quot;

Set RS_Users = Server.CreateObject(&quot;ADODB.Recordset&quot

Thanks.

 

[codestorm]

Ahh, in that case it would go in the DSN.
Haven't dealt with DSN's for a while, but
there should be somewhere you can view
the contents of the DSN. It will probably
be something like
DRIVER=Microsoft Access Driver (*.mdb)
DBQ=<drive>:\<path>\<dbname>.mdb

just add

pwd=<password>

under those codestorm