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: [2020-08-07 10_25_45-Dialog - 3_309 - Microsoft Access Connector (Connect to Ms access)] If you like, you can also pass the DB password in using a preceding String Configuration node and assigning the flow variable.

This worked perfect and was easy. thanks

KNIME Forum Archive

MS Access Password Protected Database

KNIME Analytics Platform

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled