Delphi 2009/2010 and Access 2007 database

Question

How to connect to a accdb using Delphi 2009/2010 and adoconnection (design time)?

Answer 1

Use Microsoft Office 12.0 Access Database Engine OleDB Provider instead of Microsoft Jet 4.0 OLE Db provider on the connection string.

If you don't have the Acccess 2007 or 2010 instead on the machine, you can download the Microsoft Access Database Engine 2010 Redistributable