dsn connection from hosting service

[scottr]

Hi im haveing my site hosted by a service and i would like to password protect the db.How can i access the db with a dsn connection. Do i have to put the password in the code, if so it seems like the hosting guys could go into it if they like? Any suggestions would be appreciated. Im also password protecting the website, so if you could get into the db then you have control of the site, this will all be done using asp. Im also using access 2000.

Regards,
Scott

Usually the password would go in the DSN (get begging to that webmaster guy!! :) ) Think you can put the password in the code too, try:

"DSN=database.mdb; password=dfvsjhbfv"

or

"DSN=database.mdb; pwd=dfvsjhbfv"