ASP running in 64 bits environment with Access database

Question

I have a customer since 2003 running a simple web site built in asp 3.0 with an access database file (.mdb). Recently that customer aquired a new server that came with windows 2003 server 64 bits and the web site doesn´t function any more, showing this message:

ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed.

Of course I allready did some web research and found that it seems to be a problem with 64 bit environment using mdb files (access database). I don´t know what to do. Code for connecting with database:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dados\politics\consulta\camara.mdb;MODE=Read;Jet OLEDB:Database Password=1234;"

P.S. In 32 bit environment everything works OK. I really need some help here. Thanks.

Answer 1

Have you set IIS to run in 32-bit mode? You probably need to make the config change suggested by Microsoft.

Answer 2

I am not sure if Access 2010 is of use to you, but it might be worth checking as it mentions 64-bit.