07-17-2017 01:56 AM
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
Solved! Go to Solution.
07-17-2017 02:42 AM
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.