Ole automation for update data in MS Access

[former_member1163516]

I all,

i have this problem:

i wont modify one or more record in a db ACCESS, i can insert, i can select but i can't modify or delete.

-i use this code for insert: sql = 'INSERT INTO [ZDEBUGGER] (NUMERO, FLAG) VALUES(4, 3)'. it's work fine

CALL METHOD OF rec 'open'

EXPORTING #1 = sql

#2 = con

#3 = '1'.

-for modify: sql = 'UPDATE ZDEBUGGER set flag = 2 where numero = 3'. it's do not work.

CALL METHOD OF rec 'open'

EXPORTING #1 = sql

#2 = con

#3 = '1'.

please, help me?

[Former Member]

Hi Maurizio,

please check your program code.

Best regards,

CM

[Former Member]

Dear Experts,

I have the same problem, can someone submit a proposed solution?

with best regards,

Lars.