LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

unable to create table in microsoft access 2010

Solved!
Go to solution

hi, i want to create a table of information so i started first from create db tool and gave simple column names.

But got this errror and  no output to my access.mdb 

 

error message-NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Create Table.vi->information.vi<ERR>ADO Error: 0x80040E14
Exception occured in Microsoft JET Database Engine: Syntax error in field definition. in NI_Database_API.lvlib:Conn Execute.vi->NI_Database_API.lvlib:DB Tools Create Table.vi->information.vi 

0 Kudos
Message 1 of 2
(2,896 Views)
Solution
Accepted by topic author ransher

The error is clear on what is wrong. 

The field names that you have selected is not valid. 

Make sure that you do not use reserved words in the names. 

Date, time and maybe Password is reserved. 

Message 2 of 2
(2,880 Views)