.accdb problems in CF

Question

I am running coldfusion 9I am in trh process of converting 2003 access DB's to 2007 DB's. The extension of the DB changes from .mdb to .accdb. When I attempt to update the datasource in the CF admin, it does not even see the 2007 database and only displays the 2003 as an option even though I know they are both sitting there. How does coldfusion handle the new Access extension?

JR__Bob__Dobbs · Answer

I don't think that the drivers bundled with CF are compatible with the Access 2007 format. Someone please correct me if I am mistaken.

Options:

1. Locate a JDBC driver for Access 2007 and configure it per the guidelines in the CF documentation.

http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf3639b1-7fe6.html

http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe9.html

2. Use the ODBC to JDBC bridge.

It appears that you can get an ODBC driver from Microsoft. An ODBC driver for Access 2007 *may* already be installed on a machine with Office 2007.

http://www.microsoft.com/downloads/en/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Configuring an ODBC datasource in CF:

http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe3.html

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded