Search and Display Access Records

[rhalko]

Hello,

            Does anyone now of a easy way to use Labview to search records in a Access database and display records that meet the search criteria?

Thanks,Randy

[dan_u]

Randy,
The easiest way is to use the database toolkit to execute SQL queries. There's a predefined SELECT VI. Just enter the table and the
fields you want to retrieve and a clause for the search criteria. For more complex SQL queries use the SQL execute VI and fetch the data. You'll get the records back as 2D-array of variant.

Daniel

[bburress]

Hi Randy,
    Here is a link describing the Database Connectivity Toolkit for LabVIEW.  It should allow you to communicate easily with Access Databases.

http://digital.ni.com/demo.nsf/websearch/2a659f8dc899dac486256ab7000424dd?opendocument