Connecting Access Database to Labview

[jlopez94]

Hi, 

I'm trying to connect an Access Database to one of my projects in Labview. However, I am running into a lot of issues on getting the data to write into one of the tables that I have in the database. One error that i keep getting is:

Possible reason(s):
ADO Error: 0x00000001
Argument error. One of the column names specified is blank.

I've attached a copy of the vi to this post. Please help!

[Bob_Schor]

I've not tried to do this, myself, but I did go on the Web to see if it was possible.  I found this (recent) Article from NI, Accessing Microsoft Access using LabVIEW, which starts with the following "warning": 

• Make sure the development computer has both Microsoft Access and Microsoft Access database Engine installed - the necessary software can be found on Microsoft's site. Most computers do not have the database engine installed by default, which can result in difficulties when creating a UDL file. 

See if this helps with what you are trying to do.

Bob Schor

[jlopez94]

Hi,

Thank you for the article! I have been able to create a table in the Access Database from Labview but I have not been able to insert data into that table yet from Labview.