I use LabVIEW DB Toolkit to access databases.
I opened a microsoft access database with the connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\test3.accdb".
When I exeucted
create table leq_octave_5min ( recorded_time DATETIME CONSTRAINT pk1 PRIMARY KEY,
LEQ5 FLOAT CONSTRAINT leq5 NOT NULL,
MIN FLOAT CONSTRAINT min NOT NULL,
MAX FLOAT CONSTRAINT max NOT NULL,
L05 FLOAT CONSTRAINT L05 NOT NULL,
L10 FLOAT CONSTRAINT L10 NOT NULL,
L50 FLOAT CONSTRAINT L50 NOT NULL,
L90 FLOAT CONSTRAINT L90 NOT NULL,
L95 FLOAT CONSTRAINT L95 NOT NULL,
FR01 FLOAT CONSTRAINT fr01 NOT NULL,
FR02 FLOAT CONSTRAINT fr02 NOT NULL,
FR03 FLOAT CONSTRAINT fr03 NOT NULL,
FR04 FLOAT CONSTRAINT fr04 NOT NULL,
FR05 FLOAT CONSTRAINT fr05 NOT NULL,
FR06 FLOAT CONSTRAINT fr06 NOT NULL,
FR07 FLOAT CONSTRAINT fr07 NOT NULL,
FR08 FLOAT CONSTRAINT fr08 NOT NULL,
FR09 FLOAT CONSTRAINT fr09 NOT NULL,
FR10 FLOAT CONSTRAINT fr10 NOT NULL,
FR11 FLOAT CONSTRAINT fr11 NOT NULL,
FR12 FLOAT CONSTRAINT fr12 NOT NULL,
FR13 FLOAT CONSTRAINT fr13 NOT NULL,
FR14 FLOAT CONSTRAINT fr14 NOT NULL,
FR15 FLOAT CONSTRAINT fr15 NOT NULL,
FR16 FLOAT CONSTRAINT fr16 NOT NULL,
FR17 FLOAT CONSTRAINT fr17 NOT NULL,
FR18 FLOAT CONSTRAINT fr18 NOT NULL,
FR19 FLOAT CONSTRAINT fr19 NOT NULL,
FR20 FLOAT CONSTRAINT fr20 NOT NULL,
FR21 FLOAT CONSTRAINT fr21 NOT NULL,
FR22 FLOAT CONSTRAINT fr22 NOT NULL,
FR23 FLOAT CONSTRAINT fr23 NOT NULL,
FR24 FLOAT CONSTRAINT fr24 NOT NULL,
FR25 FLOAT CONSTRAINT fr25 NOT NULL,
FR26 FLOAT CONSTRAINT fr26 NOT NULL,
FR27 FLOAT CONSTRAINT fr27 NOT NULL,
FR28 FLOAT CONSTRAINT fr28 NOT NULL,
FR29 FLOAT CONSTRAINT fr29 NOT NULL,
FR30 FLOAT CONSTRAINT fr30 NOT NULL,
status TEXT(2) CONSTRAINT st NOT NULL)
I retrieved an error saying "ADO Error: 0x80040E14".
I had no problem with an ODBC driver.
Why do I get such an error with Jet OLE DB?
