Problem to delete an ACCESS table and then recreate it

[Anonymous]

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

[manodwhb]

@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

[Anonymous]

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

Error tAccessRow

[manodwhb]

@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.

[manodwhb]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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

General viewComponent: tAccessInputComponent: tAccessOutput