How can I add a password to this JDBC:ODBC connection string that is trying to connect to an MS Access database

Question

This is the connection string that is currently working on a non-password protected MS Access database.

this code snippet is from our properity file:

db.url = jdbc:odbc:Driver\={Microsoft Access Driver (*.mdb)};Dbq\=C:\Inventory.mdb;DriverID\=22;READONLY\=true

How do I add a password to this connection string for a MS Access DB protected by a database password (Non-ULS)?

Thanks!

Answer 1

Referenced from here: Java Support

db.url = jdbc:odbc:Driver\={Microsoft Access Driver (*.mdb)}Dbq\=C:\Inventory.mdb;DriverID\=22;READONLY\=true; UID\=me;PWD\=secret