I hope that this is the correct group to post this question, however am
having a problem that I can not seem to fix. I have been working with it
for 3 days.
The problem is that one of my fields (the field named Text ) in my Access 97
database is a memo field. When I leave out this field from my Sql statement,
all runs fine. However, when I add it I get the message "Syntax error in
UPDATE statement" . I've tried putting the Text field at the end of my
statement, and I've tried double single quotes and all types of
combinations. There must be a way so that I can update a memo field. Can
anybody help me? Thank you in advance very much.
SqlText = "Update PressRelease Set Title='" & Title & "',Location='" &
Location & "',Text='" & Text & "' WHERE ID=" & Session("T0ID")