i'm new to Knime and am having trouble opening a MS Access Database file of type "mdb". I'm using the Database Reader component. The Database driver is the default -- "sun.jdbc.odbc.JdbcOdbcDriver". I cannot seem to create a Database URL that works. I've tried the pathname to the target file. Also, I have tried things like jdbc:odbc:. I always get an error indicating that either the driver won't accept the url or a "datasource name too long" message.
See http://tech.knime.org/node/20275