Unable to check if MS Access table exist in Database

Anonymous — Sat, 16 Nov 2024 05:30:28 GMT

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

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 ?

Re: Unable to check if MS Access table exist in Database

Anonymous — Wed, 26 Jun 2019 08:38:39 GMT

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