Rights For ASP Connection To Access DB

[Art Cabot]

I have an Active Server Page talking to an Access database on IIS6. What
rights are needed to the folder where the .mdb resides in order to write to
the tables?

This is on a corporate server where they REALLY have things secure!

 

[Kevin Jameson]

you cant do this with microsoft access 2003

you must upgrade to access 20004 by clicking here:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html

HTH

Kevin

 

[Art Cabot]

Thanks, Kevin, but all that's being used is an Access back-end database in
MDB format, we're not using Access on the front-end at all. And this DOES
work, sort of. We used to be able to write to the MDB and right now the
Active Server Page can READ from the MDB, but since the company moved the web
server to a new box, we've lost the rights we had set up so that the Active
Server Page can WRITE to the MDB.

I think that all that's needed is for the local IUSR_xxx user to have write
rights to the folder where the MDB is stored, but I'm just trying to get a
reality check here in the forum.