how to use DB toolkit to input string >255 into ACCESS Database

[Jcardinal]

I am converting an existing LV-Application from LV5.1.1 w/SQL toolkit to LV7.1 with DB-Conn. Toolkit.  One of the tables in my MS-Access database has a field of TYPE=memo (allows string lengths > 255 characters).  I can't seem to find how to insert this field in the DB-table using the "DB Tools Insert Data.VI" without getting an error.  I have tried converting the input string to a [U8] array, but that also doesn't work.  Just inputing the long string (390-chrs) also gives an error.  Reducing the string length to < 255 allows the new record to be input into the table without errors.  However, I need to be able to input the longer strings for the application to work.

Does anyone have a solution to this problem.

Thanks,

Jim Cardinal

[tst]

Instead of using the Insert Data VI, try using the Execute Query VI in the advanced palette. You can wire a full SQL query into it.

[DavidJCrawford]

Something like this

David

Message Edited by David Crawford on 01-12-2006 11:53 AM

[Jcardinal]

Thanks for the quick responses.  I will give this a try.  It looks like it should solve my problem.

Jim Cardinal

[PincoG]

Hi to everybody, with this post I found a solution do insert string >255 into MS Access Type = NOTE.

I still have the problem reading data when a field NOTE contain a string >255.

It gives me "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.".

Seems it do a table for query, using String instead of NOTE.

Any Idea?

Thanks

[DavidJCrawford]

Make sure your field is "long text" and not "short text"
Data types for Access desktop databases - Access (microsoft.com)