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

You must double the double quote

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