Access 2007 , getting CF to recognize .accdb file?

Report · May 20, 2009

We have CF7 running. Just upgraded to Access 2007, which creates .accdb files instead of .mdb files.

I found on these forums that I needed to install the 2007 Office System Driver: Data Connectivity Components (we're running IIS) on the server. Used this URL http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=7554f536 -8c28-4598-9b72-ef94e038c891

The administrators installed that and it went okay.

Someone put in these forums that after they installed the new components, when they used CF Data Sources and added a new data source, that the MS Access line comes up as "Microsoft Access Driver (*.mdb,*.accdb)" in the Add New Data Source screen.

We rebooted the whole server but the list in Drivers still shows just "Microsoft Access", and thus still only recognizes .mdb files.

Anyone know how I can get the "Microsoft Access Driver (*.mdb,*.accdb)" to show up in the Driver popup?

Thanks!

Howard Perlman

hperlman@usgs.gov

Report · May 20, 2009

These drivers are ODBC drivers so you'll first need to define your

datasource in the ODBC Control panel and then use the ODBC Socket

driver in the CF Administrator.

Mack