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!