Accessing Tables in MSAccess with Table Selector Node
I am using the MSAccess Connection Node to successfully connect to an MSAccess database. I am then linking this node to the Table Selector Node and am unable to display any tables from this database. I also tried querying the table directly in this node with the custom SQLStatement … I only get: “WARN DB Table Selector 0:10 net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.4 user lacks privilege or object not found: PMATTBASE”
I can access the table just fine since Access does not require credentials (outside of KNIME).
Under the Database Metadata Browser I am only seeing: Schema → Public
Any suggestions of what I am doing wrong to display these tables?