Unable to Detach Database in a Compiled Project - Labview 7.1

[neil_mcs]

We have recently left our customer, running a compiled version Labview 7.1 project. Since running the compiled project he cannot perform his Historical Data Back-up. The following error is reported:

"This operation cannot be completed because the resource is in use by another Client

Archive 09Sep08 (archive name) - Failed to detach associated relational database"

Any guidance and advice would be greatly appreciated

[sahpe]

Hello Neil,

I have had a look at other instances where we have come across a similar issue. Here is some information that I found:

Microsoft's ActiveX Data Objects (ADO) are used for accessing data sources. They provide a means of accessing data stores. Although your program runs quite quickly, there must be an ADO connection in the background still running, and the connection does not get closed until some timeout occurs within ADO so that you can have access.

 

The short-term workaround might be to wait an extra minute or so before detaching the database in your code.

I hope that this will help,

Please do let me know how it goes,

Kind Regards,

Michael S.
Applications Engineer
NI UK & Ireland