Tuesday, 1 November 2011

Connecting to Microsoft Access Databases with ACCDB Extension

[Formate] The Microsoft Access Database Component of Office 2007 and 2010  uses the ACCBD file extension for its database files. Many sites save the databases as .MDB files however if you wish to use an .ACCDB database you will need to download the relevant Microsoft Office System Driver from the URL below.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

This will add a new data source driver to the database driver list when creating a new System DSN from Control Panel\Administrative Tools\Data Sources (ODBC). You can then create the required ADO string in the usual manner. (JH)