ODBC Connection for MS Access

• Click on Start button
• Select Control Panal
• Click on Administrator Tools
• Click on Data Sources (ODBC)
• ODBC Data Source Administrator window will open as below screenshot

• To Add MS Access User Data Source, Click on Add button
• Create New Data Source window will open

• Select “Diver do Microsoft Access (*.mdb)”  from Create New Data Source window and click on finish button.
• ODBC Microsoft Access Setup Window will open

• Write Data Source Name and Description if need,
• Click on Select button  and select mdb file from the location (see below screenshot)

• Click on OK button after selecting mdb file

• Database will display under ODBC Microsoft Access Setup window and click on OK button

• MS Access User DSN Will display MS Access Driver name.