Tuesday, May 18, 2010

Access Database Engine Redistributable 2010

This is great news as it makes it possible to make add-in programs for example for AutoCAD 64-bit to access MS Access databases. Among JTB World’s software I plan on implementing this for ACAD_db and ACA_db. If there is a need for it JTB FlexReport could be supported as a native 64-bit application and still have the option to support MS Access databases, not sure if there is any pressing need for it though.

Formerly known as Office Connectivity Component, Access Database Engine 2010 is now available in both 32-bit and 64-bit. It is available in 9 languages. You can download it here.

This download will install a set of components that can be used by non-Microsoft Office applications to read data from and write data to Office 2010 system files such as Microsoft Access 2010 (mdb and accdb) files and Microsoft Excel 2010 (xls, xlsx, and xlsb) files.

  • If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.14.0”
  • If you are connecting to Microsoft Office Excel data, add “Excel 14.0” to the Extended Properties of the OLEDB connection string.
  • If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
  • If you are application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”

Some of the latest blog posts

Subscribe to RSS headline updates from:
Powered by FeedBurner