Home All Groups Group Topic Archive Search About

Rights For ASP Connection To Access DB

Author
19 Sep 2006 12:26 AM
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!
--
Art Cabot
Director, Information Technology
Sizemore, Inc.

Author
19 Sep 2006 2:07 PM
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
Show quoteHide quote
"Art Cabot" <ArtCa***@discussions.microsoft.com> wrote in message
news:FC3FB7EF-C5BD-4430-A4C5-B540AB54E5E0@microsoft.com...
>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!
> --
> Art Cabot
> Director, Information Technology
> Sizemore, Inc.
Author
19 Sep 2006 4:16 PM
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.
--
Art Cabot
Director, Information Technology
Sizemore, Inc.


Show quoteHide quote
"Art Cabot" wrote:

> 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!
> --
> Art Cabot
> Director, Information Technology
> Sizemore, Inc.