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

Discussion in 'General Off-Topic Chat' started by oliverhoffmann, Mar 28, 2016.

  1. oliverhoffmann
    OP

    oliverhoffmann Newbie

    Newcomer
    1
    0
    Mar 28, 2016
    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.