Does anyone know how CF can interact with the new 07 Access DB

[Guest]

I am running coldfusion 9

I  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?

Will Adobe be fixing this in an upcoming patch?

[Deb]

They need to be set up using the ODBC Socket driver rather than the Access driver.

Here's a blog post with the steps:

http://blogs.adobe.com/vikaschandran/2010/12/03/creating-ms-access-2007-database-accdb-extension-dat...