Connect to MS Access database (AnyDAC)

This is a AnyDAC Database Connectivity entry
Feel free to add your notes to this topic below.

Supported versions

The AnyDAC native driver supports the MS Access 95, 97, 2000, 2003 and 2007 databases.

AnyDAC requires:

the "Microsoft Access Driver (*.mdb)" ODBC driver version 3 or higher to be installed on the workstation (often referred to as the MS JET ODBC Driver) for 95-2003 databases. Details.
the "Microsoft Access Driver (*.mdb, *.accdb)" ODBC driver version 12 or higher to be installed on the workstation for 95-2007 databases. Details.

DriverID=MSAcc

Parameter	Description	Example value
Database	The path to the MDB file.	c:\mydb.mdb
SystemDB	The path to the system database file.	c:\mysystem.mdb
ReadOnly	Specify True to open a database in read-only mode. False is the default value.	True
ODBCAdvanced	Allows you to specify any other additional ODBC connection parameter value. The default value is "ExtendedAnsiSQL=1".	IMPLICITCOMMITSYNC=NO

DriverID=MSAcc
Database=c:\mydata.mdb

Repair MS Access database. Specify REPAIR_DB=<path_name> in ODBCAdvanced. Do not specify the Database parameter. More info. Example:

DriverID=MSAcc
ODBCAdvanced=REPAIR_DB=c:\mydata.mdb

Compact MS Access database. Specify COMPACT_DB=<path_name><optionaL_sort_order><optional ENCRYPT keyword> in ODBCAdvanced. Do not specify the Database parameter. More info. Example:

DriverID=MSAcc
ODBCAdvanced=COMPACT_DB=c:\mydata.mdb

DriverID=MSAcc
Database=c:\mydata.mdb
SystemDB=c:\system.mdb
UserName=usr
Password=pwd