Database connectivity toolkit

[MoAgha]

Hello,

I am using Database connectivity toolkit to create a Microsoft access database.  I am new to the toolkit.  I have been reading the tutorials online and following the instructions.  I created a blank Microsoft Access file with a .mdb extension.  I also created a .udl data link through Tools>Create Data Link... in LabView and linked it to the mdb file.  My VI code is attached.  I get the following error when I run the program (also attached).  I am not sure what causes this error.  I appreciate your help.  

Thanks

[nyc_(is_out_of_here)]

What do you want to achieve?

You say you are able to create a new empty Access file.

[MoAgha]

I manually created the Access file (which is blank).  I need to edit it and insert data through LabVIEW.

[Dennis_Knutson]

What is your actual table name and columns? Did you create both with Access? It sounds like you are new to databases.

[mikeporter]

There are several issues here:

1. You said you created the mdb file manually, how did you do that?
2. What is the structure of the table you are trying to insert data into?
3. How did you create that table?
4. What does the connection string to the database look like?

I agree with Sir Dennis that you do sound very new to databases. Check out this link for some useful background.

In terms of the error message you are getting, the reason for it is not only unknown, but only knowable with a lot of effort. the reason for this unhappy situation is that the DCT hides the logic that generates the error, but passes error messages back to you unmodified. Consequently, most of the errors you get from the DCT are largely useless.

Mike...

[MoAgha]

Hello Mike and Sir Dennis,

Thanks for the link.  I will be reading it.  I am new to databases.  Here are answers to your questions.

1. I opened MS Access 2013, created a blank database, and saved it as an mdb file. 

2. The table is not created.  I was trying to get LabVIEW to create the table. The VI I am creating will be testing the performace of some sensors and return a number of values with the date of testing.  I need the returned values and date to be added as  new rows to the database every time a test is conducted.  However I am trying to have LabVIEW create the table the first time a test is conducted.  

4.  It is actualy a cluster.  It has three rows and one column.  They are 33,3,and 78.  The title is Table.  The numbers are arbitrary in the example. 

This is the format of the table I am trying to achieve.  

Table 

1    33

2    3

3    78

Thank you for your help!

[Dennis_Knutson]

An insert will not create a table or the columns.

[aputman · Accepted solution]

you cannot create a table with the name "table".  that is a keyword.

[MoAgha]

I changed the Table title and that seem to have done it.  Thanks!

[mikeporter]

Have you double-checked the contents of the database? Doing an insert should not on its own accord create a table for you.

Mike