このコンテンツは設定された言語で表示できません。

このコンテンツは表示可能な別の言語で表示されています。 お使いのブラウザに翻訳機能がある場合はご利用ください。

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

Updated Jan 19, 2023

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 

Related Links

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.