DB Tools Close Connection VI hangs since Access update this month

[AndreasC]

Open and write to an access.accdb runs without error, but when I want to close the connection reference, the VI hangs. Only close task helps.    This appears since the last Office/Access update.  The behavior is also in applications that I created before the updates.

Our IT department tries to restore the status before the updates.

I'll keep you informed

Andreas

[mikeporter]

Which version of Windows? Also, is it that Access is hanging or is the DCT VI hanging?

I use Jet databases regularly and have not seen a problem on Win7 or 10. Two differences are that I don't use the new accdb format, second I don't use the DCT.

It might be worth writing a couple small test programs to see what is breaking.

Is this happening on more than one PC? Has IT installed anything new?

Mike...

[AndreasC]

Mike,

my Windows is version 7/32, Labview 2014. Definetly this VI hangs in invoke-node close.

Neither the IDE works nor compiled applications. But they did before the access update run, also on different machines. Our IT is searching for it. One suggestion I heard maybe an antivirus definition file. We'll wait and see.

Andreas

[AndreasC]

Here is closer information about the update. Sorry it's in German ...

[Brandizzl]

Hey AndreasC,

the update you just posted (KB3114731) is an Junk-Mail filter update for Outlook. I think is the interesting one:

February 9, 2016, update for Access 2016 (KB3114522)
https://support.microsoft.com/en-us/kb/3114522

 Is there any error you receive from LabVIew?

Greets

Brandizzl

[AndreasC]

Hey Brandizzl,

labview returned no error message. When i run in debugging mode I see the vi hanging (green arrow stops in the vi). Inside the VI it hangs in the invoke node (close methode).

Meanwhile our IT department solved the problem. They excluded some branches of the antivir definition paths they distributed with the office update.

Andreas

[Brandizzl]

So is your program running again?

[AndreasC · Accepted solution]

Yes, all is fine. apps and the IDE