"invalid precision value" when inserting into access db

[labviewette]

Dear Community,

I am using LabVIEW Data Connectivity Toolkit to insert long text into an access database field of the type "long text". See attached vi.

The error i get is: invalid precision value.

Only 255 charakters can be written to access. After that i get this error.

I have tried:

- creating an access form for my table to avoid inserting data into the table's raw datasheet.

- changing the text format of the access field into "rich text" rather than "text only".

This did not help.

Do I need to search for a solution working with activeX to communicate with access instead of using the DCT?

Thanks in advance!

[Gevor]

This topic might be helpful

https://forums.ni.com/t5/LabVIEW/Error-updating-database-entry-with-text-longer-than-255/td-p/332358...

[FireFist-Redhawk]

I can't open your VI because I'm using 2017 (save for 2017 and share if you're still stuck after a while), but have you tried using the old data type of "memo"?

[Martin_Henz]

The NI toolkit itself knows only a very limited number of data types. It assumes, that a string is allways a varchar which ist limited to 255 characters. This might be the reason, why you get an error.

Some ideas:

- build your own SQL insert statement and use DB Tools Execute Query from the advanced palette

- or use another toolkit

- create a child class which corrects this issue

- make your own toolkit