ASP here to MS Access on another server?

[ljb]

I have a ASP running on one web server trying to access an Access database
on another file server. The problem is WebServer doesn't have permissions to
open the db on FileServer. On FileServer I expected to be able to grant read
permission to IUSR_WebServer but that account doesn't exist in FileServer's
list to choose from. What do I need to do?

FileServer is also a domain controller. WebServer is a standalone Win 2000
server. The error I get seems to indicate access denied. If I copy the same
database to WebServer and use server.mappath("db.mdb") to create the connect
string it works fine. For the other location's connect string I skip the
server.mappath and provide a full UNC path.

thanks
LJB

 

[Bob Barrows]

I have a ASP running on one web server trying to access an Access
database on another file server. The problem is WebServer doesn't
have permissions to open the db on FileServer. On FileServer I
expected to be able to grant read permission to IUSR_WebServer but
that account doesn't exist in FileServer's list to choose from. What
do I need to do?

FileServer is also a domain controller. WebServer is a standalone Win
2000 server. The error I get seems to indicate access denied. If I
copy the same database to WebServer and use server.mappath("db.mdb")
to create the connect string it works fine. For the other location's
connect string I skip the server.mappath and provide a full UNC path.

http://www.aspfaq.com/show.asp?id=2168
--
HTH,
Bob Barrows - ASP MVP
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

 

[Tom Kaminski [MVP]]

I have a ASP running on one web server trying to access an Access database
on another file server. The problem is WebServer doesn't have permissions to
open the db on FileServer. On FileServer I expected to be able to grant read
permission to IUSR_WebServer but that account doesn't exist in FileServer's
list to choose from. What do I need to do?

FileServer is also a domain controller. WebServer is a standalone Win 2000
server. The error I get seems to indicate access denied. If I copy the same
database to WebServer and use server.mappath("db.mdb") to create the connect
string it works fine. For the other location's connect string I skip the
server.mappath and provide a full UNC path.

http://www.aspfaq.com/show.asp?id=2168

 

[ljb]

Thanks for pointing me to that document. I haven't yet verified that it
works in my situation but will try soon.