Skip to main content
A
Anonymous
January 6, 2011
Question

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

  • January 6, 2011
  • 1 reply
  • 368 views

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?

    This topic has been closed for replies.

    1 reply

    D
    Deb
    Participating Frequently
    January 6, 2011

    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-datasource-with-coldfusion-9/

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices