Hi everyone.

I have a problem,have tried to find the solution,but it seams to miss it..

I'm using db created in MS Access 2003,and have a problem with memo field..
I'm beginner so forgive me if I'm doing something crazy,that's the way I so as best...This is the code..

1 Code:
  1. strSQL = "INSERT INTO Table (ID, memoField1, memofield2) "

  2.      strSQL = strSQL & "VALUES (?, ?, ?)"

1 Code:
  1. .Parameters.Append .CreateParameter("ID Number", adInteger, adParamInput, , inserter)

  2. .Parameters.Append .CreateParameter("Memo1", adLongVarChar, adParamInput, 400, txtField1.Text)

  3. .Parameters.Append .CreateParameter("Memo2", adLongVarChar, adParamInput, 500, txtField2.Text)

I have used "adVarChar" and "adLongVarWChar",and I need to be able to insert at least 500 characters into memo field...

The problem is that if I put 500,error occurs and it's also if I don't put anything...
As seen I'm using parameters,also ADO and mdb...
I am able to insert other data that is before this,and it's in the database so I have access to it and am able to insert just not in the memo field.

The error is next:
Run-time error '-2147217900 (80040e14)':
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement

Before it was about missing parameters and then about incomplete info (without 500)..

I hope I gave enough of info s o You can help me.
Thank You for Your time and effort..