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

Updated Jan 19, 2023

Reported In

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.

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

Collaborate with other users in our discussion forums

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

Open a service request

Learn about software subscriptions and services

Learn about hardware service programs

Yes