Connection String for MS Access

Connection String for MS Access

Connection String is a string which contains database connection information. Then,  it will be passed to the Driver Manager and driver (ADO) directly.

Beside that, The connection string need to be formatted as below form:

Argument1=Value1; Argument2=Value2; Argument3=Value3;…;ArgumentX=ValueX

Example:
Provider=MSDASQL; DRIVER={Microsoft Access Driver (*.mdb)}; UID=; PWD=SamplePassword; DBQ=C:\Domains\sample.net\db\sample.mdb;

Please refer to the following article to know more. 
Knowledge Base: Connect to MS Access Database