Adding data to Access DB with connectivity toolkit?

[BernieSAIC]

I am trying a new way to add data to Access instead of AciveX due to not knowing the commands needed to interact with it.  Instead I am trying to use the database connectivity toolkit and learn some new techniques.  This is also an introduction to variants which may be causing me this issue.

Problem:  Trying to add data to multiple columns in the database in the same record line.  I can add one piece of data to one column fine but cannot figure out how to add data to multiple columns with different names.

The approach I am using is to open a new line and add the first element.  I then try to stay in the same record by using the go to previous record vi but all it does is create a new record for each element.  I am sure it has to do with the way I am configuring the arrays of data and how the insert data vi handles it.

Attached is the vi.

Thanks

[jjgors · Accepted solution]

I don't have the database to test this, but I believe you need to keep the data in a cluster and then you should be able to add all of the columns at once without having to add each column one at a time.

[BernieSAIC]

I could have sworn I tried this to start with and it didn't work.  I tried it again and it worked fine.  Thanks.