LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

MS ACCESS write data doubt, help please !!

The attached MS ACCESS write vi is showing errors.

 

I tried my level maximum, but could not get the reason behind it.

 

I am attching the vi and also the access file.

I installed MDAC 2.6 and Labsql for the dataaccess.

 

Please help.

 

Thanks in Advance.

Regards
Grugh Mike

Success is Everything !!
Download All
0 Kudos
Message 1 of 3
(2,482 Views)

I can't open your vi, however I noticed you used "date" as a column name.

"Date" is a reserved word for Access: try to rename the column (e.g. "Date_txt") or use the syntax with square brackets [date].

Paolo
-------------------
LV 7.1, 2011, 2017, 2019, 2021
0 Kudos
Message 2 of 3
(2,473 Views)

Hi grugh,

 

I have your vi downloaded and opened it just fine, but to debug your problem, I'm going to need some more information:

 

1) What errors are you getting? If you could post the exact error text or error number that would be great!

2) Can you post of screenshot of your front panel before you run the vi? I'm specifically looking at how you're entering your string control.  This would also be helpful if we could see your error out cluster.

 

Have a good day,

 

Chris V

 

 

Applications Engineer
National Instruments
0 Kudos
Message 3 of 3
(2,444 Views)