Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu Sep 13 10:57:54 CDT 2007
Could you just delete the TMP files yourself before closing the app? Rocky -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT Helps Sent: Thursday, September 13, 2007 12:07 AM To: Discussion of Hardware and Software issues Subject: [dba-Tech] Mcafee Viruscan Central slows down closing form from 1to 40 seconds. Hi I found this pretty gross of McAfee so I wanted to know if someone had the same issue and what you done to resolve it. I have written an application in Access for inventorising a real estate property in order to generate a value estimation of the property. The application keep a list of question and answer and generates a form to display on a tablet pc which is carried around the property by the expert. The form is pretty large around 16 tabs and a combined number of +/- 500 questions and their answers. It is mainly this form that causes a problem with McAfee anti virus. The form is unbound and loads/saves data when opening/closing (only saves date when a change is noticed). The application was running very smootly on three computers (2 tablets, one desktop) until a certain McAfee update about 1,5 year ago. Suddenly, after this update was installed, closing the form took a huge time even without saving the data. Instead of 1 or 2 seconds, the form took 40 seconds to close, without saving data!!! We quickly found that it was the virusscanner that caused the issue. I tried to add an exclusion for MDB, but that is not posible in that Virusscanner. So we decided to deactivate the viruscanner. Yesterday, one and a half year later, I installed the latest version (11.x) Mcafee Anti Virus, and the problem still is present. I contacted McAfee support, several times, the frontline people where not really knowledgeable about there own soft and my case was escalated to a higher level. In the meanwhile I supplied them with some additional information where I believe the problem is situated. Apparantly, when I open this form, Access creates 508 temporary file in the "local settings\temp" folder. I suspect 1 for each control. The file are named "~[random].TMP". The virusscanner does not slow down the opening and getting data very much (and creating those 508 tmp files), let's say 1 or 2 seconds, for which I'm ok with. But closing the form (without saving data), delays the form from 2 to 40 seconds, it freezes Access. When I take a look at the temp folder, I see that deleting those tmp files, or whatever is related to that action, is what causing the delay. Files are fully deleted after those 40 seconds. What is causing the delay of 40 seconds, is it deleting those 508 tmp files or is it some MDB updating that is done before deleting each file? Because the form has worked perfectly for a period of 2 years togheter with Mcafee, until a certain update, I suspect McAfee added the TMP extension to the "document and programs" list (the virusscaner has always been set to doc and prog). But then again, why is McAfee freesing Access for 40 seconds while DELETING the files??? The response from McAfee was that they are aware that using MDB's with the virusscaner are problematic and they do not have a solution for it, since 1 year and a half!!! They found it was not that problematic. I told him that if the users opens this form 100 times a day (which is probably the case) he had to wait 1,5 hours per day.... I asked if I could add an exclusing to the virusscanner but this is not posible. So I said that I then my only option is to install another brand of virusscaner, he answered that the user could turn of the virusscanner off/on while he uses the form... 100 times a day!!! Great support :-( I used to love McAfee, but the problems I have with them and the level of support in the last 2 or 3 years are sickening. Erwin Craps Zaakvoerder Nieuwe internetwinkel op www.ithelps.be/shop <http://www.ithelps.be/shop> www.ithelps.be/onsgezin bezoek ook eens de website van mijn zus www.friedacraps.be <http://www.friedacraps.be/> This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be <http://www.boxoffice.be/> * www.stadleuven.be <http://www.stadleuven.be/> IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: Info at ithelps.be Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: Staff at boxoffice.be <mailto:figures at boxoffice.be> _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.485 / Virus Database: 269.13.16/1004 - Release Date: 9/12/2007 5:22 PM