Unable to connect to Access 2000 database

I am getting this error

Error Type:
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 0x4f4 Thread
0xe38 DBC 0xd28da4 Jet'.

This is the code that it is trying to run.

Set oADOConn = CreateObject("ADODB.Connection")
sConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DBPath
oADOConn.Open sConn
Set oRS=CreateObject("ADODB.Recordset")

SQL statement

What blew up?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Re: Unable to connect to Access 2000 database

Micromanaged wrote:
> I am getting this error
>
> Error Type:
> 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 0x4f4 Thread
> 0xe38 DBC 0xd28da4 Jet'.

This error is a suggestion from Microsoft that you stop using the obsolete
ODBC driver (I'm only half-joking).

>
> This is the code that it is trying to run.
>
> Set oADOConn = CreateObject("ADODB.Connection")
> sConn = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DBPath

sConn="Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & DBPath

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
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.

Re: Unable to connect to Access 2000 database

I changed the driver in the code to:

Set oADOConn = CreateObject("ADODB.Connection")
sConn="Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=" & DBPath
oADOConn.Open sConn

I now get the error on the line "oADOConn.Open sConn"

Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file
'\\servername\sharename\accessdatabase.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Re: Unable to connect to Access 2000 database

On Thu, 03 Mar 2005 09:51:51 -0800, Micromanaged
wrote:

>I changed the driver in the code to:
>
>Set oADOConn = CreateObject("ADODB.Connection")
>sConn="Provider=Microsoft.Jet.OLEDB.4.0;" &_
>"Data Source=" & DBPath
>oADOConn.Open sConn
>
>I now get the error on the line "oADOConn.Open sConn"
>
>Microsoft JET Database Engine (0x80004005)
>The Microsoft Jet database engine cannot open the file
>'\\servername\sharename\accessdatabase.mdb'. It is already opened
>exclusively by another user, or you need permission to view its data.

See the FAQ:

Why do I get database-related 80004005 errors?
http://www.aspfaq.com/show.asp?id=2009

Jeff

Re: Unable to connect to Access 2000 database

Smashing reply. Looked up the FAQ and discovered that the
iusrr_computername account was lacking permissions to read the access
database.

Thanks for the info Jeff.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Re: Unable to connect to Access 2000 database

On Thu, 03 Mar 2005 13:56:09 -0800, Micromanaged
wrote:

>Smashing reply. Looked up the FAQ and discovered that the
>iusrr_computername account was lacking permissions to read the access
>database.
>
>Thanks for the info Jeff.

Don't thank me, than Aaron for maintaining it. :)

Jeff