Windows 7/Office 2007 Missing Jet OLEDB 4.0 Driver

Report · Nov 06, 2009

Please excuse my warped terminology as I'm a web site designer not a web developer. I've just upgraded to Windows 7 Home Premium, 64 bit, after my machine died a flaming death. I have several sites that uses an ODBC DSN connection using the Jet Driver 4.0 when I was on XP to connect to an Access db. After the installation of Dreamweaver and Access 2007 on the new machine, I went to the administrative tools/ODBC Data Sources to setup my ODBC connection and the only options are for SQL Server and SQL Native Server. If you step through these screens the Jet Driver is not available, all of the other types of connections are also not present.

My connection string from the XP machine was "<add key="MM_CONNECTION_STRING_CHJAdbcon" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:/inetpub/sites/www.chja.org/web/database/CHJA2009.mdb;Persist Security Info=False" />.

Does anyone know if the Jet Driver 4.0 is gone and is there an article somewhere that can help me fix this problem? I've searched the Microsoft Support Web Site and can't seem to find anything on this. I've loaded and rebooted the AccessDatabaseEngine.exe. I have a backup laptop that is still on XP, but I need to go forward on Windows 7 with my development work.

thanks,

Lori

Report · Nov 08, 2009

The problem isn't Windows 7, the problem is 64-bit. MS Access is 32-bit oly and MS has no announced any plans to create a 64-bit version. I would take the jump and install MS SQL Server on your XP system, upsize your databases to MS SQL Server and use that. The Express version of MS SQL Server is free.

Obviously there are other alernatives to MS SQL Server as well. For real database servers you can look into MySQL and PostgreSQL, but an interesting other option is the embedded Apache Derby database that comes with ColdFusion. All that sort of depends on what else the databases are used for.