We use a program called ChurchHelpmate which is built in a Microsoft Access database.
We are running on a peer-to-peer network of Win XP and Win 7 computers with McAfee Antivirus Plus installed.
Recently, we started getting error messages during the startup of the ChurchHelpmate program.
The error messages indicated that MS Access was unable to get a file lock on one or more of its datafiles.
Following an extensive investigation with the assistance of the ChurchHelpmate support staff, we discovered the cause of error messages.
1) If we turn off Real-Time Scanning in McAfee Antivirus or change the settings to scan "Programs and Documents only", the error messages go away.
2) If Real_Time Scanning is turned on with the setting scan "All files (recommended)", the error messages occur.
It would appear that the Real-Time Scanning is locking datafiles during its processing which is blocking MS Access access to the datafiles.
Is there an alternative to disabling a portion of the McAfee Antivirus program?
Note: this problem has only arisen recently. The installation has been error-free for the last 2 years.
There is a similar thread regarding the same issue here: https://community.mcafee.com/thread/61373?tstart=0
Perhaps follow the advice given there.
Technical Support may be the best route for this, linked under Useful Links at the top of this page.
The more cases they get the better.
Message was edited by: Ex_Brit on 19/10/13 9:27:04 EDT AM