DB Tools Create Table

[sharinganez]

Hi.. i got this error while trying to create a database

Conn Execute.vi->DB Tools Create Table.vi->CreateDatabase.vi<ERR>Exception occured in Microsoft Office Access Database Engine: Syntax error in CREATE TABLE statement. in Conn Execute.vi->DB Tools Create Table.vi->CreateDatabase.vi

[pincpanter · Accepted solution]

I cannot open your vi, however in many cases the syntax error is caused by invalid table or field names (invalid characters, embedded blanks or reserved words). In this case, you may want to change names; alternatively, you may enclose them in square brackets: [my_column_name].

If you open the DB Create Table.vi -> Conn Execute.vi block diagram you can capture the full text for the SQL query and post it so we can take a look at it.

[KateB]

1. What is the database you use?

2. Please fill in all controls on frontpanel, and right click on them>>Data Operations>>Make Current Value Default. Then, save, and attach it again.

3. Also re-attach screenshot that could show full error code together with UDL file, and database file (if possible).

[sharinganez]

Hi pincpanter

Yea you are right!

its Table name problem

After i change it, its ok now.

Thanks pal!