01-06-2004 11:06 AM
01-06-2004 12:15 PM
01-06-2004 12:56 PM
01-06-2004 02:39 PM
01-06-2004 03:58 PM
01-06-2004 04:21 PM
01-07-2004 07:33 AM
01-07-2004 10:02 AM
01-07-2004 11:16 AM
02-06-2006 02:40 PM
I applied the same approach as you guys have described,
however my problem starts before I get to autonumber.
I have an issue feeding column (data) from "DB tool list column VI"
to "DB Tools insert data VI" .So when I connect column
output of "DB tool list vi" to column input of "Insert data Vi
" I get an error message "exception occurred in Microsoft OLE DB
Provider for ODBC Drivers, [Microsoft][ODBC Microsoft Access Driver] Syntax
error in INSERT INTO statement.."
However, when I don’t connect column between those two vias, basically leaving
it blank ( it treats it as filling all the columns in database) and it works
fine that way.
I talked to NI engineer and he couldn't figure out exactly what causes that
problem, ”DB Tools List column vi" outputs correct column info, which
corresponds correctly to my created data base. I am suspecting it could have
something to do with ODBC driver or version of Access that I am using.
Access version is 2003, and I tried ODBC driver of 2002 & 2004 with the
same results.
Any help would be appreciated