Based on the forum post you found and the limitations of the UCanAccess driver, it looks like this won’t work. (That said, I am not a DB expert and am happy to be corrected by someone who knows better and has a magic bullet solution!)
IIRC when I was researching this issue, it did look like there were a couple of Access drivers that would support, but they cost money, so I stopped researching the issue. My ‘solve’ was to export the table I needed from Access into a server/folder. Access gives you the ability to “Save export steps” and integrate it into Outlook as a Task which makes it a one-click export, without ever having to open Access again. I believe there is also a way to have Windows Task Scheduler kick off the export from Access, completely removing any human element, but for me, I don’t need hourly/daily exports of this, so I stick with the one-click export whenever I have to run the KNIME workflow that needs this table.
If you do find a different solution though, please post!