Identify table if existing on a mdb.file

[Gambit]

Hi guys,

Is there any other node aside from Database List Tables Node and database Table Exists IF Switch Node that I can use to identify if a specific table is existing on a mdb.file? Currently I was using Microsoft Access Connector to read the mdb.files but Database List Tables Node and database Table Exists IF Switch are not compatible since it was for legacy type nodes only.
Your suggestions will be of great help.

Thanks,
Gambit

[ScottF]

Hi @Gambit -

Those are nodes from the Vernalis community extension, so let me tag @Vernalis and @s.roughley to see if they have plans to support the new DB nodes.

[Gambit]

Hi @ScottF,

Thanks for the support. Really appreciate it Sir.

Regards,
Gambit

[Vernalis]

Thanks Scott.

We are working with KNIME on making these available, hopefully to coincide with the KNIME summer release. Unfortunately, a few minor changes are required to the inner workings of the KNIME new ‘DB’ plugins in order to make this possible. I will post in the @Vernalis category about this too, as there are others who have contacted us about these nodes too.

Steve

[Gambit]

Hi @Vernalis ,

Thank you for the response. Do you have any recommendation regarding this? I am reading a .mdb type file on my local PC. Can I use other .mdb file reader that is compatible with the nodes I mentioned?

Br,
Gambit

[Vernalis]

I’ve not really used Microsoft Access mdb files as a database source, but if you want to stick with the old style connection then the following two forum topics might help:

Reading Microsoft Access Database

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. Surely this is a simple thing to do – I…

and

[solved] Microsoft Access (error with jdbc url)

Hello to All, First, I would like to mention that I have read topic https://tech.knime.org/node/20275 describing how to configure Knime in order to access Microsoft Access and that I searched the forum database for other topics related to Microsoft Access, without finding a way to solve my problem. I apologize for opening a topic again on this subject. Here is what I did: 1/ I reinstalled Knime (32 bits because of problem of compatibility with odbc and 64 bits) 2/ I created a DSN…

Otherwise, if you want the new DB-style connections now, then the only think I can think of at the moment is some sort of try-catch node set-up around a

DB Table Selector

Steve