Problem with inserting into MS Access Memo field.

Hi, I have an ODBC named store in MS Access. There's a table called desc which has bookId(Number) and summary(Memo).
My code to insert data into the table is:

import java.util.*;
import java.sql.*;
import java.io.*;

class Book{

public static void main(String args[]) 
    {
          List exc=new LinkedList();
         int bookId=11;
        String summary="The Photoshop CS4 Bible is the only book you need to succeed in any Photoshop endeavor. It shows readers how to retouch, color correct, manipulate, and combine images using Photoshop. Readers can learn to create cutting-edge special effects for their digital or film-based images, and use them on the Web or in print. The easy and approachable writing style demystifies even the most complex Photoshop tasks. You'll master every aspect of Photoshop-- from image-editing basics to techniques for working with camera raw images. Other topics covered include the File Browser, histogram palette, Lens Blur, Match Color, the color replacement tool, customizable keyboard shortcuts, and more.";
         
    try{
        
    
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }
        catch(ClassNotFoundException cnfe)
        {
            exc.add(cnfe);
        }
        
        Connection con=DriverManager.getConnection("jdbc:odbc:store");
        if(con==null) { exc.add("con=null");
}

PreparedStatement psumm=con.prepareStatement("insert into desc values(?,?)");
       
   int size = summary.length();
BufferedInputStream bais = new BufferedInputStream( new ByteArrayInputStream( summary.getBytes() ) );

psumm.setInt(1,bookId);
     psumm.setAsciiStream(2,bais,size);
     
      
      
      int t=psumm.executeUpdate();
       
        psumm.close();
        con.close();
        
    }catch(SQLException se)
    {
        exc.add(se.getMessage());
        
    }
    
    if(exc.isEmpty())
        System.out.println("true");
    else
    {
            System.out.println("Errors!");
        Iterator i=exc.iterator();
        while(i.hasNext())
        {
            System.out.println((String)i.next());
        }
        
      }

}
}

The output which I am getting in Netbeans is:

Errors!
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
BUILD SUCCESSFUL (total time: 0 seconds)

Any help,please?

Have you tried the following:
- psumm.setString(2, summary);
- psumm.setCharacterStream(2, new StringReader(summary));
- psumm.setClob(2, new StringReader(summary));

Or, for unicode:
- psumm.setNString(2, summary);
- psumm.setNCharacterStream(2, new StringReader(summary));
- psumm.setNClob(2, new StringReader(summary));

1. The table in MS Access cannot have a name desc, so changed the name,still, the above are not working.
2. setString gives : General error
3.psumm.setCharacterStream(2, new StringReader(summary)); gives: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
4.psumm.setClob(2, new StringReader(summary)); also gives: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect

Is there a way to convert the string to a Clob and then use setClob()? And if I am using CLOBS, the data type in MS Access should be what?
I've got a project to submit tomorrow, this is taking too much time!

Can't find the solution, I just need to store looooooong strings in MS Access. Suggest a way,please!

A few more attempts:

You can also try to convert the column to Text. If I recall correctly that can handle large amounts of text as well.

It worked!

I just had to change the table name to something else than desc. The code I posted worked with memo.
I'll try out your suggestions also. Thanks!

You're welcome.