Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI

Document Type: Example Program
NI Supported: Yes
Publish Date: Sep 6, 2006

Obtaining Table and Field Names from a Microsoft Access Database Using Data Access Objects (DAO) in LabVIEW

11 ratings | 4.09 out of 5
Print

Downloads

Filename: daoinfo.zip
Requirements: View

The attached VIs use ActiveX to obtain the table names and field names from a Microsoft Access database programmatically.

Requirements


Filename: daoinfo.zip

Software Requirements


Application Software: LabVIEW Full Development System 7.0
Language(s): LabVIEW

 
11 ratings | 4.09 out of 5
Print

Reader Comments | Submit a comment »

Cet exemple est très bien
- Oct 19, 2005

examples need small change to prevent memory leak
These examples were helpful for me! Here's a minor comment. In the for loop in each example, one has to close the instance that is opened, for example "field" in the DAO_Fields.vi. Each instance in the for loop creates a separate block in memory. Each instance must be closed to release that memory. This is important when your lv program runs for a long time and does thousands of calls to the database. LV does survive,but the OS eventually has no more memory to hand out.
- William Van Drent, ADE Technologies, Inc. wvandrent@adetech.com - May 16, 2003

 

Legal
This example program (this "program") was developed by a National Instruments ("NI") Applications Engineer. Although technical support of this program may be made available by National Instruments, this program may not be completely tested and verified, and NI does not guarantee its quality in any way or that NI will continue to support this program with each new revision of related products and drivers. THIS EXAMPLE PROGRAM IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND SUBJECT TO CERTAIN RESTRICTIONS AS MORE SPECIFICALLY SET FORTH IN NI.COM'S TERMS OF USE (http://ni.com/legal/termsofuse/unitedstates/us/).