Creating an OLE DB Microsoft Access database alias

The procedure to create a database alias with the OLEDB driver differs from that for other drivers:
  1. Select Relational Provider from the Provider list.
  2. Select OLE DB from the Driver list.
  3. Specify the path to the database file in the Server field.
  4. Select Microsoft Jet 4.0 OLE DB Provider from the OLEDB Driver list.
  5. Leave blank the Database field.
  6. On the Authentication tab, select Basic authentication.
  7. Specify the required user name in the Name field.
  8. Leave blank the Password field.
  9. Click the Advanced tab.
  10. In the User-defined properties field specify:
    Jet OLEDB:Database Password =[password];