
Updating data to a memo field using SQL UPDATE
I am having trouble updating data to a memo field using an SQL
UPDATE query in VB 4.0 with jet2.5.
The following code is generating the error message 3075 (Syntax
error in query expression):
SQL_Stat = "UPDATE Mailings SET [Mailing_Fields] = '" & Sats & "' WHERE [Mailing_Name] = '" & Text2.Text & "'"
Dbase.Execute SQL_Stat
The field Mailing_Fields is defined as a memo field.
Any suggestions would be grateful
Axel Bendix