The happens when the MDB file is on a mapped network drive that can only a named user can access.
There are three possible solutions:
–Or–
–Or–
logonuser=username:logonpassword:password.
Note When you use logonuser
and logonpassword
, the specified account on the JDBC-ODBC Bridge server machine must match the account on the machine the network drive is mapped to. If you don't do this, the connection will fail. For example, if the JDBC-ODBC Bridge server machine has a local account JOBUser
with password 1234abcd
and the machine hosting the Access MDB file has a local account JOBUser
and password xyz
, the connection will fail.