From 11:00 PM CST Friday, Feb 14th - 6:30 PM CST Saturday, Feb 15th, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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,503 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,494 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,465 Views)