Access database Memo data types

[Sanjib Biswas]

Hi,

I am trying to add record (INSERT INTO...) into a Memo field in the
access database. But the ExecuteNonQuery() throws an exception. "Syntax
error (missing operator) in query expression "<field value>"". Also note
that <field value> is a string and has apostrophes in two places. For text
field I am sending with apostrophes around the field value and it works.

Does any one know, what I am missing here?

Regards
Sanjib

 

[Sanjib Biswas]

I got the answer Chr(34) + <field value> + Chr(34)

 

[Sanjib Biswas]

By the does any know, the correct way to insert a Memo record into Access
database? Because even after adding quote before and after the field value
does not work all the times. Sometime, I had to pass double quote 'Chr(39)'
to get it working.

Regards
Sanjib