Be careful with Kaspersky Anti-Virus!

Yesterday I got a phone call from my client, he told that a new version, I sent recently, does not work and produce a lot of errors. Weird! I changed only a query in last version, and did not even touch VBA code. So I start to ask him what he did before <g>, with his PC, and he told me, that he just installed (or upgraded) Kaspersky Anti-Virus. Yes, this is it! Kaspersky Anti-Virus blocks some VBA code in order to prevent macro viruses run. So this was a source of the problem. Fortunately – there is an option, where you can switch off VBA blocking.

First time I noticed this long ago, in Access 2000 time. I have installed my application on a new PC with Office 2000 – and it did not work. I started to debug, and found that some function simply not working. It took me some time to find out that is was Kaspersky Anti-Virus – I had reregistered VBA libraries, reinstalled Office. I think default behavior should be – than Anti-Virus gives user a message that it blocks VBA, when application starts.