Thanks for all the great feedback everyone! I'm pleased that it sounds like there is a reasonable solution. I have a few questions though.
First, just to clarify - I am inputing a large text field into an access database using labview 8.0.
I verified that the field in the database is indeed a memo field. However, anytime I insert text that is larger than 255 chars, i get the "Invalid precision error in rec create" error. it works fine if I make the text smaller than 255.
This happens even if I have any >'< 'ticks' in the string or not.
I am using a .dsn file to connect to my database. I don't see any options to change the provider I am using similar to the "Data Link Properties" window you show below. Where do I do this? I tried creating a new .udl file and setting the "Data Link Properties" to the "Jet" Provider but anytime I test the connection to my database i get the "Test connection failed because of an error initializing provider. Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
What am I doing wrong? I really appreciate the help and quick response!
matt
QUOTE(xtaldaz @ Jun 18 2007, 11:19 AM)