>Verify the column in your db is really memo.
>then put a response.write sql to write down your
>sql insert statement and then try to execute it straight
>into the access db...

Hi Giovanni,

The field is memo. When I copy the data into Access manually it fits.

I don't use a sql. Instead I use the AddNew method. Adding works, the 
data is there since I can see it on the screen. I can even see the part 
of the text that is not written to be database.

I chop up this text and use the AppenChunk method to write it to the 
database. The chunks itself are OK, I can see them on the screen. Only 
the first chunk is written, the rest is disregarded.

I have the idea I should open the database differently or with other 
parameters as just AppenChunk does not seems to work.
Ciao,

Richard

ok.
verify the column in your db is really memo.
then put a response.write sql to write down your
sql insert statement and then try to execute it straight
into the access db...



-----Messaggio originale-----
Da: Richard Hagen [mailto:Richard.Hagen@c...]
Inviato: giovedì 25 luglio 2002 16.39
A: ASP Databases
Oggetto: [asp_databases] Re: R: How to store large strings (>255
characters) in Access?


> do you use POST or GET method to pass the data from the form?

I use Post.
I checked with response.write and thhe data arrives at the asp page.
Ciao,

Richard