How to use asp script to insert long text to a memo field

[chakhorn T]

Due to limited size of sql query string, I cannot update memo filed (in MS
Access) with long text.
so the statement Conn.execute("insert into tblhelpme values("memo.......(1000
characters).............") did not work.
Can I use other method to update memo field using asp script?

Chakhorn T.

[Brett]

"chakhorn T" <chakhorn@yahoo.com> wrote:
>
>Due to limited size of sql query string, I cannot update memo filed (in
MS
>Access) with long text.
>so the statement Conn.execute("insert into tblhelpme values("memo.......(1000
>characters).............") did not work.
>Can I use other method to update memo field using asp script?
>
>Chakhorn T.


It's been awhile since I've used Access - but, I think you are limited to
255 characters. (I think.) Hmmm....

[David]

"Brett" <brett@erevsolutions.com> wrote:
>
>"chakhorn T" <chakhorn@yahoo.com> wrote:
>>
>>Due to limited size of sql query string, I cannot update memo filed (in
>MS
>>Access) with long text.
>>so the statement Conn.execute("insert into tblhelpme values("memo.......(1000
>>characters).............") did not work.
>>Can I use other method to update memo field using asp script?
>>
>>Chakhorn T.
>
>
>It's been awhile since I've used Access - but, I think you are limited to
>255 characters. (I think.) Hmmm....

A memo field in an access database can hold up to 64,000 characters.......

Dave