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
    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.
     
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice