Error -2147467259 Occurs Randomly While Accessing Microsoft Access from Multiple PCs in LabVIEW

Updated Dec 31, 2024

Reported In

Software

  • LabVIEW
  • LabVIEW Database Connectivity Toolkit

Other

  • Microsoft Access

Issue Details

I am using multiple local PCs to access a a local database file (.mdb) created using Microsoft Access. However, I encounter error -2147467259 randomly and unpredictably.

Solution

Microsoft does not support placing Jet .mdb files under high user load. Microsoft strongly recommends that you use Microsoft SQL Server or Microsoft Data Engine (MSDE) instead of Access when high user loads (that is, more than 15 instances) are required or anticipated, especially when updating is required.

Additional Information

To run an .mdb file by multiple instances, Jet makes use of a lock delay and retry interval. However, under high load conditions, you may exceed these intervals. 

Related Links

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.