[RESOLVED] Update Syntax in Access not the same as in vb 6 code why?

[salsa31]

Og for the love of ENIAC....
CN.Execute "UPDATE Customers SET FullName = Replace(FullName,"","", """")"

first a case of not enough double quoting... then a case of too much in the wrong spot ....
Replace takes three paramerters, the haysatck, the needle and what to replace it with... this will look in FullName find , in the text and replace it with an empty string...
We're not building rockets here folks...

-tg

well sir that didnt help

CN.Execute "UPDATE Customers SET FullName = Replace(FullName,"","", """")"

i still get the same error