Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI
5 ratings:
 3.79 out of 5     Rate this Document

Why Does My LabVIEW Application Leak Memory when Logging to an Access Database?

Primary Software: Enterprise Connectivity Toolset
Primary Software Version: 3.0.1
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem:
If you use the LabVIEW SQL Toolkit to repeatedly log data to an Access database, you may see that your LabVIEW application allocates more and more memory.

Solution:
This is actually a behavior of Access and NOT a bug in the LabVIEW SQL Toolkit. Refer to the Microsoft KnowledgeBase Article 313011 for an explanation of how to set up your registry so that this does not happen.

Related Links:
External Link: Microsoft Support

External Link: Microsoft Article 313011: Jet Memory Usage Increases When You Insert New Records
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 1XMGJUHE: Can I Use LabVIEW to Open an Access Database Without Using SQL Functions?
KnowledgeBase 2MJ6PPFP: Error 1 Using the LabVIEW Database Connectivity Toolset to Connect to a Microsoft Access Database

Attachments:





Report Date: 10/06/1999
Last Updated: 06/04/2009
Document ID: 1Q5G4DJ6

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