IIS file permissions help please.. groan, heh!

**RowaN** · 31st July 2003

I'm running a website where users details are stored on a Access database. In order to prevent people downloading the database I need to take away the NTFS anonymous access currently set on the file. This would be replaced with an NTFS user name and password, which would prevent anon download, but which would also mean that all the VBScript programs that access the database would have to log in as this new NTFS user in order to read and write data to it...

My problem is that I don't know how to open the database file using a specific user name and password in the code ... I currently open the file using a "db.Open 'DSN='"statement, and the database username and password are embedded in the DSN definition. There is a syntax when using the 'db.Open' statement that looks something like:

db.Open "DSN=blah; UID=username; PWD=password"

but I couldn't get this to work!!

Any help much appriciated.

**RowaN** · 31st July 2003

*please* see:

http://www.digital-forums.com/forum/...hreadid=180748

**nickstan** · 31st July 2003

Do you have access to any none-web directories?
Its much easier and securer to sit the database in a normal directory where theres no web access allowed at all.

**RowaN** · 31st July 2003

Thanks. Thats what I had suggested (trying to solve this problem for a colleage) but he rubbished the idea. Just explained it to him again and now he understands. Some people, tut!!