MS Access Password Protected Database

I have an Access Database that I am connecting to which is password protected. Does anyone have a sample workflow to share on how to pass the db password into the workflow. I am getting an error the user does not have access privileges.

Hi @Coconut598 and welcome to the forum -

You can add the password manually as a JDBC parameter, like this:

If you like, you can also pass the DB password in using a preceding String Configuration node and assigning the flow variable.

3 Likes

This worked perfect and was easy. thanks

2 Likes