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

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