ASP and Access DB

Hello,

I am getting an Error #80004005

It reads as follows:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x16a0 Thread 0x133c
DBC 0x9cc0d2c Jet'.

/header/connect.inc, line 5

The code reads as follows:

<%
Function Connect ()
Set DB = Server.CreateObject("ADODB.Connection")
ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" +
Server.MapPath("database/UsersTest.mdb")
DB.Open (ConnStr)
Set Connect = DB
End Function
%>

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Everything is good here as I have identical files in another directory on my
web server and the code works in the other location but in this location, for
some reason, I get this registry error.

Can anyone tell me how to fix this?

Thanks

McKirahan
Thu Jan 26 12:37:25 CST 2006

"glenn" <glenn@discussions.microsoft.com> wrote in message
news:764A8921-47C8-4217-A7C6-E036D53BBD16@microsoft.com...
> Hello,
>
> I am getting an Error #80004005
>
> It reads as follows:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
> registry key 'Temporary (volatile) Jet DSN for process 0x16a0 Thread
0x133c
> DBC 0x9cc0d2c Jet'.
>
> /header/connect.inc, line 5
>
> The code reads as follows:
>
> <%
> Function Connect ()
> Set DB = Server.CreateObject("ADODB.Connection")
> ConnStr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" +
> Server.MapPath("database/UsersTest.mdb")
> DB.Open (ConnStr)
> Set Connect = DB
> End Function
> %>
>
>
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
''''''''''''''''
> Everything is good here as I have identical files in another directory on
my
> web server and the code works in the other location but in this location,
for
> some reason, I get this registry error.
>
> Can anyone tell me how to fix this?
>
> Thanks

Try using this instead
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
of
"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="