java - 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