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

Updated Oct 9, 2020

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: 0x80000001 Argument error. The number of columns does not equal the number of parameters.
  • 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. 
  • Confirm the datatype of the inputs specified in DB Tools Insert Data VI. You can try to use cluster datatype to avoid this kind of issue