Academic Company Events Community Support Solutions Products & Services Contact NI MyNI
28 ratings:
 3.10 out of 5   

Can I Use LabVIEW to Open an Access Database Without Using SQL Functions?



Primary Software: LabVIEW Development Systems>>LabVIEW Full Development System
Primary Software Version: 2014
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem:
I would like to use LabVIEW to open a Microsoft Access database. Can I do this without resorting to SQL functions?

Solution:
There are a few methods to communicate with Access in LabVIEW. The NI LabVIEW Database Connectivity Toolkit, which is included in LabVIEW Professional, is the preferred method of database communication with LabVIEW. The LabVIEW Database Connectivity Toolset offers many powerful tools and extended capabilities for quickly accessing databases. The LabVIEW Database Connectivity Toolset offers connectivity to most popular databases through Microsoft ADO technology, complete SQL Functionality, and the ability to save records in XML format. It provides both easy-to-use and advanced functions to allow common database operations as well as detailed database accessibility.

You can also use ActiveX Automation to open Microsoft Access and control many aspects of the Access Application. For actual database manipulation however, the Access automation classes rely upon the Microsoft DAO (Data Access Object) and/or ADO (ActiveX Data Object) classes. These classes can be used independently or through the Access automation classes to read and write data into an Access database. These classes can be difficult to use and may require a fair amount of SQL knowledge to accomplish a complicated task.

For more information about the Microsoft Access automation classes, DAO or ADO classes refer to the Microsoft website and Developer Network:

Microsoft Home
Microsoft Developer Network


Related Links:
NI LabVIEW Database Connectivity Toolkit
KnowledgeBase 2KFB4NOU: Creating a Microsoft Data Link file (.UDL) for Connecting to Microsoft Access in LabVIEW
KnowledgeBase 2J5H09DJ: Can I Access MDE Files Using the LabVIEW Database Connectivity Toolset on a Machine Without Microsoft Access?
KnowledgeBase 2MJ6PPFP: Error 1 Using the LabVIEW Database Connectivity Toolset to Connect to a Microsoft Access Database
KnowledgeBase 1Q5G4DJ6: Why Does My LabVIEW Application Leak Memory when Logging to an Access Database?


Attachments:





Report Date: 05/23/2000
Last Updated: 08/21/2017
Document ID: 1XMGJUHE

Your Feedback! poor Poor  |  Excellent excellent   Yes No
 Document Quality? 
 Answered Your Question? 
  1 2 3 4 5
Please Contact NI for all product and support inquiries.submit