Hi,

My ASP page needs to access (read/write) to an .mdb file located on a 
different server than the one running IIS and my web site.

Here is my code
Set objConn= Server.CreateObject("ADODB.Connection")
objConn.Open("DRIVER={Microsoft Access Driver *.mdb)};DBQ=\\server2\folder2
\common\tablename.mdb")

When this code executes I get the following error:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open 
registry key 'Temporary (volatile) Jet DSN for process 0x874 Thread 0x8c8 
DBC 0x14bdd64 Jet'.

Does this have anything to do with permissions? if so, where and how would 
I set them up ?

Anyhelp would be greatly appreciated.

IUSR_<machinename> account is local to the webserver and can't be assigned
rights to remote resources. I have posted the answer to this problem many
times in the past (check the archives), but the two basic solutions are:
a) change anonymous internet user account to a domain account -or- create
two local accounts, one on each machine, with the same username/password
b) use authenticated access, where the NT credentials you supply are domain
accounts

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Jae Hou" <jae@s...>
To: "Access ASP" <access_asp@p...>
Sent: Thursday, March 06, 2003 9:29 PM
Subject: [access_asp] accessing MS Access database on different server


: Hi,
:
: My ASP page needs to access (read/write) to an .mdb file located on a
: different server than the one running IIS and my web site.
:
: Here is my code
: Set objConn= Server.CreateObject("ADODB.Connection")
: objConn.Open("DRIVER={Microsoft Access Driver
*.mdb)};DBQ=\\server2\folder2
: \common\tablename.mdb")
:
: When this code executes I get the following error:
:
: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
: registry key 'Temporary (volatile) Jet DSN for process 0x874 Thread 0x8c8
: DBC 0x14bdd64 Jet'.
:
: Does this have anything to do with permissions? if so, where and how would
: I set them up ?
:
: Anyhelp would be greatly appreciated.