LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to add data to an access database with connectivity toolkit?

Hello,

 

I'm trying to add data to an access database using the connectivity toolkit of Labview.

 

At this moment, I have one row in my database: [Lindex lindex 0 0 0] with the first two elements of string type and the last three elements of double type. I want to add a new row [Hello hello 0 0 0] in my database using the "Insert Data" block, but it doesn't work properly. 

 

Can anyone help me out?

Thanks!

 

0 Kudos
Message 1 of 4
(2,779 Views)

You've closed the connection to the database before your Write operation.  Don't do that!

 

2017-11-30 10_14_08-Nieuwe gebruiker.vi Block Diagram.png

Jim
You're entirely bonkers. But I'll tell you a secret. All the best people are. ~ Alice
For he does not know what will happen; So who can tell him when it will occur? Eccl. 8:7

0 Kudos
Message 2 of 4
(2,760 Views)

I did an edit to my vi, but it still gives an error (see picture). I also took a printscreen of my access database.

 

Can u also tell me how to get the coercion dot away?

 

Thanks!

 

 

Download All
0 Kudos
Message 3 of 4
(2,733 Views)

Your Columns-array to the Insert to DB is empty.

/Y

G# - Award winning reference based OOP for LV, for free! - Qestit VIPM GitHub

Qestit Systems
Certified-LabVIEW-Developer
0 Kudos
Message 4 of 4
(2,723 Views)