XP 64 Bit, IIS and Access 2000

Any help with this is appreciated.

I upgraded my pc to 64 bit motherboard, processor and XP 64 bit.

When I try to access an Access 2000 database, using ASP on my local pc I
receive an error "'800a0ea9' Provider is not specified and there is no
designated default provider."

The offending code is "strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
Source=" & Server.MapPath("/db/sample.mdb")" It works fine on the net and the
db is located under wwwroot/db/.

I'm a newbie to IIS, but I'm pretty sure I have permissions correct.

Thinking it's a driver issue I've downloaded the latest jet, but on instal
this errors "This KB829558 is for a different hardware platform."

Thinking it may be MDAC I downloaded MDAC_TYP.EXE, but this errors "This
setup does not support installing on this operating system."

My code works fine on the hosting server, so I don't feel it's the code.

Cheers

Graham McAllister

 

There is no 64bit Jet support, so access databases won't work in 64bit.
You'll have to switch to 32bit

 

Does this mean if I want to run IIS with Access 2000 I need Win XP Pro, not
Win XP Pro 64 bit?

I'm suspect Microsoft is not supporting Access 2000 databases for online,
instead preferring developers use SQL or mySql.

Thanks for your input.

Cheers

Graham McAllister