Access database Memo data types

  • Thread starter Thread starter Sanjib Biswas
  • Start date Start date
S

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
 
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
 
Back
Top