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

[salsa31]

hey
i have a code that update a certain field if it contains this mark [']
when i run it in the access table it works fine
when i run it in the vb 6 code i get a error why?
this is the code
in access

UPDATE Customers SET FullName = Replace(FullName,"'","")

in vb 6

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

tnx for any help
salsa