Hi @ScottF
Thanks for sharing.
I manually add the password as JDBC parameter, but Knime shows an error: UCAExc:::4.0.4 Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.
I pretty sure the password is correct. Is there any other setting need to be done?
Hi @Amy1007 and welcome to the forum. (I split your question off into a separate topic to keep things tidy.)
Right now this is not currently supported with the way we implement the UCanAccess driver. We have a ticket in our system to address this (AP-14848), and I will add a +1 from you.