ADO Error 0x00000001 or 0x80040E14 When Writing Data to Access Database

Updated Jan 11, 2018

Reported In

Software

  • LabVIEW Professional
  • LabVIEW Base
  • LabVIEW Full
  • LabVIEW Database Connectivity Toolkit

Issue Details

I am trying to write data to a Microsoft Access Database using ActiveX Data Objects (ADO). I receive these errors: 
  • ADO Error: 0x00000001 Argument error. One of the column names specified is blank. 
  • ADO Error: 0x80040E14 The INSERT INTO statement contains the following unknown field name. 

Solution

  • Confirm the number of columns matches the number of data elements specified in the DB Tools Insert Data VI.  
  • Delete any blank, initialized elements in the columns input. Initialized elements will appear in full color, as opposed to greyed out. 
  • Confirm that the column input specified in LabVIEW matches the column name in your database table. 

WAS THIS ARTICLE HELPFUL?

Not Helpful