Unable to check if MS Access table exist in Database

[Anonymous]

Hi everyone,

in my talend project, i'm retrieving datas from MS Access tables, stored in .mdb files.

Sometimes, these files does not contain the same tables. Let's say

• File 1 : Contains tables A, B and C.
• File 2 : Contains tables A and B.

Is there a way to test if table C does exist before retrieving datas from it ?

I'm already tried with a tDBInput component by asking the MSysObjects tables.

But I got this error :

UCAExc:::3.0.3.1 user lacks privilege or object not found: MSYSOBJECTS

Has someone experienced this ?

[Anonymous]

Hello,

Please go to repository/metadata/database connection/your DB connection and right click on it and select "retrieve schema".

If your connection is well parameter you will see you table and can import schema.

Best regards

Sabrina