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

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.

                New to ADManager Plus?

                  New to ADSelfService Plus?