Create a program that uses a DB to be shared

[Nando88]

I made a small example, but its not working, and I was wondering if you could please check it out.

I am using access 2016 and LV2016.

[aputman]

Do you get an error?  What does it say?

I'm going to assume that you do get an error, something about wrong datatype.  If so, you need to cluster your data, not convert it to an array.  An array is not a valid datatype for writing to a dB.  Read the help file for the DB Insert Data VI and look at the entry for the data input.  It explains how the function interprets the clustered data, depending on the number of columns and if you have a columns input wired up.  

[Nando88]

I am getting no error, it just doesn't save anything.

How should I write multiple values to db?

Please take a look at the VI.

Thanks.

[Nando88]

How would I do this, with mdb 2003?

[Nando88]

Someone please help!

I really need to finish this.

Thanks.

[aputman]

Don't be pushy.  We all have jobs.  

Create a text file on your desktop and rename it to test.udl.  Double click the UDL and configure a connection using the proper OLEDB driver (your VI says you are using Jet.OLEDB), point it to your dB file and test the connection.  Does this work?  If so, edit the UDL file with a text editor and post what you see in the file.  You should see something like this:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Persist Security Info=False; Data Source=MS Access Database

[Nando88]

It says: ensure it is a valid data link file.

[aputman]

You are going to have to be more descriptive.  Did you test the connection?  Do you get a successful connection?  Take a screenshot of the Provider and Connection tabs.  I need to see what OLE drivers are installed.  Do you have Jet or Ace driver installed?  If not, you will need to go download one of the other.  

[Nando88]

Connection succeeded, but still can't store data in db.

[Nando88]

I found the labview has version 4, but I need version 12.

I was also wondering if its possible to use the udl you told me to create, and that established connection, instead of a connection string?