- Overview
- This VIs has been built to create or drope tables in an Access DataBase
- Description
- This example uses a MS Access "Test Results" Database to show how to programmatically create or drop a Table and how to connect to an Access Database
-
Requirements
- LabVIEW 2012 (or Compatible)
- Database Connectivity Toolkit
- MS Access 2013 (or Compatible)
- Steps to Implement or Execute Code
- Run the VI
- Write a the name of the column you want to create/drop
- If you're going to create a column, you have to create the array of clusters, each position in the array will be a column in the table. For each column you have to set the name, data type, size (only if it's a string) and check the box if the column will allow null values.
- If you create a column and you need to select the Primary Key, then use the "primary key (Column) to choose which column will be the primary key (zero indexed)
- Additional informations or References
NOTE: If you just want to drop a table, yo only need to write the name of the table and click the Drop Table button.
**This document has been updated to meet the current required format for the NI Code Exchange.**