FireDAC 连接access MDB数据库的方法
Use Cases
- Open the Microsoft Access database.
DriverID=MSAcc Database=c:\mydata.mdb
- Open the Microsoft Access database using the system database.
DriverID=MSAcc Database=c:\mydata.mdb SystemDB=c:\system.mdb User_Name=usr Password=pwd
- Open the Microsoft Access password protected database. Note that the password length must be equal to or less than 14 characters.
DriverID=MSAcc Database=c:\mydata.mdb Password=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)