Virus Scanning Software is Killing Me....

[baltman]

I work for a super large company with our desktops administered remotely. Some jokers in the "security" department have done something that is slowing down my custom apps about 100 times over. There is a massive delay when I try to pass on-the-fly vba code from MS Access to Excel. Things that took seconds now take minutes.

I only have "user" rights, but I can control how Access/Excel interact. Is there any way I can escape big brother's eyes and get my work done faster... maybe some way to encapsulate the VB code so that the software doesn't realize that it's coming from an 'outside' source? My co-workers who code within Excel say they haven't noticed a performance hit...

FYI- I'm already working the squeaky wheel angle

Thanks!
Brian

 

[AVChap]

One question: What AV software are we talking about here? There was no reference to any AV software in the post. AV software is a very convenient scapegoat whenever a PC slows down. Check the settings first if it's set to scan for all files. That may account for the slowdown if ever.

Hope this helps.

AVChap

 

[baltman]

The scan is running on a computer -probably- in another state. They put McAfee on the macine locally, but it isn't *doing* anything while I'm getting slowed down. My SA also thinks that it is virus software causing the problem. I may be getting hurt much more in the waiting for network traffic to deliver my code to the server for scanning than by the scanning itself.

I don't have rights to even see what the McAfee setting are.

I was hoping I could figure out a trick to "hide" the code from whatever is causing it to be singled out for scanning.

The "Global Corporate Information Security Group" decides that all 100,000+ of us are going to be treated the same way and I'm having trouble even getting them to return my calls to get them to tell me what they *think* they are doing.

My co-worker's computer still runs my apps OK, but that's because his machine was mis-named for the virus scanner update... it "shows on a report" and will be "fixed" shortly.

I'm sure that they deliberatly choose whatever settings they are using and I'm going to have a hard time getting them to change it for me so I was hoping there was something I could do with my app's code.

I create reports on millions of records and want to put the results into Excel. The virus software sees I'm running Excel externally and eventually allows my code to run, but destroys the performance time to the point of making it more efficient to go home, run something, and go back to work (and that's 4 hours round trip for me).

Any general hints/tips would be appreciated.

Thanks!
Brian

 

[AVChap]

Better make your IT group aware of this problem since it doesn't look like a product issue, but a procedural one. Just ask them to add the directory where you put your Excel/Access files in the Exclusion list.

Hope this helps.

AVChap

 

[baltman]

If only it was that easy... red tape sucks. It'd probably be easier to buy a $500 desktop and a keyboard/monitor switchbox.

I just hope I don't recieve a crushing amout of work before this get's resolved.

Thanks,
Brian