FireDAC ways to connect to an Access MDB database

Use Cases

• Open the Microsoft Access database.

Driverid=msaccdatabase=c:\mydata.mdb

• Open the Microsoft Access database using the system database.

Driverid=msaccdatabase=c:\mydata.mdbsystemdb=c:\system.mdbuser_name=usrpassword=pwd

• Open the Microsoft Access password protected database. Note that the password length must is equal to or less than characters.

Driverid=msaccdatabase=c:\mydata.mdbpassword=pwd

Note: To Drop/create, encrypt, compact, and repair the database use the Tadmsaccessutility component.

Http://docwiki.embarcadero.com/RADStudio/XE8/en/Connect_to_Microsoft_Access_Database_ (FireDAC)

FireDAC ways to connect to an Access MDB database