Update Access Memo field from ASP.NET

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'm having difficulty with trying to update a Access memo field through an
SQL statement where the value I'm trying to pass is longer than 255
characters. The field is being truncated. I'm using a simple INSERT INTO
sql command. Anyone know a way around this?

Sample

strSQL = "INSERT INTO tblListings " & _
"(Dir, Street, City, State, " & _
"AFirst, Price, ALast, MainPhoto, Summary, Details,
UnderContract, Sold ) VALUES (" & _
"'" & dir & "'," & _
"'" & istreet.text & "'," & _
"'" & icity.text & "'," & _
"'" & istate.selecteditem.text & "'," & _
"'" & ifname.text & "'," & _
"'" & iprice.text & "'," & _
"'" & ilname.text & "'," & _
"'" & fname & "'," & _
"'" & strsummary & "'," & _
"'" & strdetails & "'," & _
"'" & ckcontract.checked & "'," & _
"'" & cksold.checked & "')"

Any help would be greatly apprciated.
.

Relevant Pages

  • Re: Using Like operator in VBA
    ... a left bracket [inside the bracket pair to test whether the string ... text string in a SQL statement that you would want to test for? ... If YourVariable contains any of the wildcard characters that are used ...
    (microsoft.public.access.modulesdaovba)
  • Re: Viewing the contents of two tables using ASP and MS Access
    ... Number of fields in a recordset 255 ... Number of characters in a cell in the query design grid 1,024 ... Number of characters in an SQL statement approximately 64,000 ...
    (microsoft.public.inetserver.asp.db)
  • Re: Logn line
    ... characters for a compact index. ... It still may be your SQL statement length. ... It gave the error message: ... The maximum length for a command line has been exceeded. ...
    (microsoft.public.fox.helpwanted)
  • Re: No more space on line of code?
    ... Sorry Kevin, I guess I was a bit cryptic. ... >> Access MVP ... >>> point where it will no longer accept any more characters. ... >>> as best I know the SQL statement has to be all on one line. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Newline inserted?
    ... > I'm assuming that those characters are part of the text. ... > This way the SQL statement ends like: ... Ronald ... Prev by Date: ...
    (perl.dbi.users)