topic Re: Problem to delete an ACCESS table and then recreate it in Talend Studio

Problem to delete an ACCESS table and then recreate it

Anonymous — Fri, 10 May 2019 10:16:38 GMT

Hello,

I have a small problem in one of my JOBS. I would like to create an access table and destroy it if it exists, the problem is when I use your component nothing happens or I have an error in the components. I attach you in my post an image of the job on which i am testing.
I took the scenario put on talend for the component ACCESS.

Job capture :

Link of the scenario :

https://help.talend.com/reader/q23BCE3W4MjloHD1RvMJ4A/DIqDtq~nOQ2iFqBb~eCrCQ

Thank you in advance for your help.

PS : Sorry for my medoicre English.

Cordialy

Guillaume

Re: Problem to delete an ACCESS table and then recreate it

manodwhb — Fri, 10 May 2019 10:19:28 GMT

@Guigui8637 , you should use tAccessRow component to execute the queries like to create and drop not tAccessInput component.

check the below link..

https://help.talend.com/reader/q23BCE3W4MjloHD1RvMJ4A/ymDc8KFGGrtAoieFd5TDRw?section=Raa17909

Re: Problem to delete an ACCESS table and then recreate it

Anonymous — Fri, 10 May 2019 10:32:32 GMT

First of all thank you @manodwhb , for you quick response but here is the error I get when tryring tAccessRow :Error tAccessRow

Error tAccessRow

Re: Problem to delete an ACCESS table and then recreate it

manodwhb — Fri, 10 May 2019 10:35:12 GMT

@Guigui8637 ,first drop the table and create.so in first component of tAccessRow you should specify the drop query and the second tAccessRow you should specify the create table script.

Re: Problem to delete an ACCESS table and then recreate it

manodwhb — Fri, 10 May 2019 11:09:23 GMT

@Guigui8637 ,If the issue resolved,please mark the solution.

Re: Problem to delete an ACCESS table and then recreate it

Anonymous — Fri, 10 May 2019 12:57:02 GMT

Re @manodwhb ,

So I did the test and i Still have a problem. My problem is that when i do the DROP-TABLE before my CREATE-TABLE it tells me that my table does not exist and in the error of creation it tells me what alreday exists.

I linked you to the catch of my job and the error obtained.

ScreenShot :

The modificationThe mistake

Regards,

Guillaume

Re: Problem to delete an ACCESS table and then recreate it

Anonymous — Fri, 10 May 2019 14:58:40 GMT

I guess i have a problem with my file and it is locally and I am in ADMINISTRATOR account on my local machine.

Re: Problem to delete an ACCESS table and then recreate it

Anonymous — Tue, 04 Jun 2019 14:34:52 GMT

Hello, here's the way to delete data in a table:

General viewComponent: tAccessInputComponent: tAccessOutput