Data Link Properties Setup for MS Access

  • If the SQL Database using MS Access (*.mdb), on the OLE DB Provider select the "Microsoft Jet 4.0 OLE DB Provider", then click Next

  • In the "Connection" tab, select the MS Access file (*.mdb)

  • Optionally, if the *.mdb file is password protected,  fill the Username and Password  and checked the "Allow Saving Password and unchecked the "Blank Password"

  • Click OK to apply changes of the Connection String