I was very happy to find out that one can use MS Access databases without the MS Office 32bit/64bit problem but could not get it working, that is to say I cannot select the UCanAccess driver in the Database Connector node (see attached file
Download UCanAccess-4.0.3-bin.zip (from https://sourceforge.net/projects/ucanaccess/files/) and copy commons-lang-x.jar, commons-logging-x.jar, hsqldb.jar, jackcess-x.jar and ucanaccess-x.jar to a local dir and select these files in the “FIle->Preferences->KNIME->Databases” and add them (see attached file ).
Each of the 5 files is listed and there is no error in the log.
I also did 1 but added the whole directory.
I tried an older version UCanAccess-3.0.7-bin.zip and did the same as in 1.
I regularly restarted KNIME after adding or deleting the jar steps. I also created new workflows and added new Databases Connector nodes.
I used the new Microsoft Access Connector but the nodes I want to use were only compatible on the legacy type nodes so I think I need to do the old procedure in connecting with .mdb files. Or if you can give other options on how to extract .mdb files and identify if a table or tables exist or not on that specific .mdb file, it would be a great help.