LabVIEW Randomly Crashes When Reading From an Access Database

Issue Details

I'm currently reading an ACCESS database (.accdb) using database connectivity toolkit and Microsoft Office 16.0 Access Database Engine. When I run the VI, LabVIEW randomly crashes. I have the error handler, but it doesn't give any error.

I'm getting an Access Violation (0xC0000005) at EIP=0x1BF86226, while using the Database Connectivity Toolkit, and LabVIEW is crashing.

Solution

• Try using a .DSN to open the database connection if you are using .UDL. If you are using a .DSN, try setting up a UDL. Here is an explanation on the difference between the two .
• If you are frequently opening and closing the database in your LabVIEW program, the Microsoft driver may be running too slow, and LabVIEW may try to open the connection before it has closed previously. Adapt your code to keep the connection open if possible. If not, include wait function to ensure about 4 seconds between opening and closing. This figure will be different for each system, but is a good starting place.
• Ensure the bitness of your database and LabVIEW is 32 bit. There have been some documented issue with 64 bit databases, and the toolkit is only supported by 32Bit LabVIEW .
• Uninstall and reinstall the Office System Driver.
• Try opening and closing the connection using the Database Connection.vi shipping example.
  • Modify the code as shown and either provide the path to your .UDL file or DSN  file, or the example one that ships with LabVIEW at the directory address shown above. On the Front Panel, change the Connection Method to match the file you are looking for. Test to see if you can run this example multiple times to isolate the issue to either you code or the database.

Additional Information