Can i link Labview to a access database?? I now activeX can do it, but which one??

[P FLETCHER]

Hi there,

I was wondering if i could link a access database to labview.
I could do with linking field as well as writing/deleting etc.

And if I could sort as well that would really be good!!!

Thanks again everyone!!!

[nicola]

Hi,
You can link labview a database, for example by using the ADO connection.

This link is possible to help you in your work.....
http://lavausergroup.org/archives/ON/files/Using_MySQL_with_LabVIEW.pdf


Hi, Nicola

[Steven Bird]

Hello Peter, You can also use the Database Connectivity toolkit for LV. Have a look at the information on NI's website. This may make life easier!

You may also be able to do this programmatically using MSQuery in Excel or Access and you can control these products using LV. This would be rather challenging though.

The suggestion made I think is also possible.

Hope this helps

Kind Regards
Steven Bird
Applications Engineer
National Instruments

[nyc_(is_out_of_here)]

I did this at my previous job.

It is not hard to do.

One thing is that you may need to download Microsoft Data Access Components (MDAC) from www.microsoft.com
if Access is not installed on the same PC as your LabVIEW program.

I was able to both read from and write to Access database tables.

A book which was helpful to me was ActiveX Data Objects for Dummies.