Access 2000 issues?

[capone67]

Hi gang

I am getting the error message below when I try to access an access 2000 database. When the Database was Access 97 it ran fine but as soon as the database was converted to 2000 boom.

Here is the code that I am using

Set MyConn=Server.CreateObject("ADODB.Connection&quot

MyConn.Open"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\inetpub\

http://wwwroot\coupons\db\coupons.mdb"

Where do I start trouble shooting this problem and what is the easiest way to fix this?

Ken

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 0x4d4 Thread 0x5a0 DBC 0x2af2574 Jet'.
/coupons/template1.asp, line 7

 

[TechnicalAnalysis]

The same connection method shouldn't have problem on Access2000 if Access97 works fine. I use the connection method below and it works fine on both Access97 and Access2000.

Dim oConn, sConnString
Set oConn = Server.CreateObject("ADODB.Connection&quot
sConnString = "DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Server.MapPath("db\coupons.mdb&quot & ";"
oConn.Open(sConnString)

Regards

http://www.technical.analysis.dingojunction.com

 

[MikeT]

Have you updated your Microsoft Data Access Components (MDAC)lately?
Get them at

http://www.microsoft.com/data

Latest version is 2.6 w/ Service Pack 1

Let us know how it turns out!

 

[capone67]

When I ran the MDAC download it seemed to extract the files and then nothing. When I ran my ASP code I still received the same eror message.

Next?

Ken

 

[MikeT]

Check this page out for some more ideas:

http://p2p.wrox.com/archive/asp_databases/2001-04/64.asp