Help get this topic noticed by sharing it on Twitter, Facebook, or email.

MS Access DB - works fine for a while, then error "can't find xxxxx.mdb" ?

Trying to learn my way around databse usage and in conjunction with Knime.
Some basic stuff I got to work, using an MS Access database (Office 2010 package 66 bit, Win 7 64 bit, Knime 64 bit, 2.11.3). But after some fiddling around, suddenly I get the following error from e.g. DB Table Selector :

ERROR Database Table Selector Execute failed: Error while validating SQL query: [Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\Program Files\KNIME_2.10.3\PostCDD_Export_from_20150924.mdb'.

Now the latter part is just odd, since my .accdb DB is installed in a different path (and connects to succesfully with DB connector). Using DB Table Connector instead gives same error as the Selector.
Most likely my SQL selection is faulty, but: this also happens if I revert to a previous correctly used SQL line.
One extreme workaround is to close all Knime, open Access, rename the table, close Access and open Knime again, but that isn't a viable solution.
1 person has
this question
+1
Reply