I'm using MX and Access 2002. I am have troubles inserting and updating to a feild in my database that has a Memo property. I am using the "Insert Record" and the "Update Record" server behaviors. I know they are working cause whenever i choose to ignore the text box that enters into the memo field, it works fine. But when i try to add/update the memo field i get an error that says:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/user/add_revieworstory.asp, line 115

any suggestions???

thanks alot
joe marshall

Whats the field called......it isn't Notes is it?

:: Son, im Thirty.... ::

The feild name is 'Text' and the data type is 'Memo'

joe

Text is the reserved word and you shouldn't be using it. Try changing field name to something else.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
The feild name is 'Text' and the data type is 'Memo'

joe
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic
www.farcic.com
TalkZone Manager