Author Topic: AVAST causes VBA issue in MS Access  (Read 2116 times)

0 Members and 1 Guest are viewing this topic.

Offline siewhoon

  • Newbie
  • *
  • Posts: 9
AVAST causes VBA issue in MS Access
« on: June 01, 2021, 05:40:50 AM »
I've been using MS Access up to before installing AVAST and have no issue all these years.  After installing AVAST Premium Security just now, I can't open my Access database anymore.  The message reads "The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted...."  Can any friend here help me with this issue.  Thank you!

Offline Asyn

  • Avast Überevangelist
  • Certainly Bot
  • *****
  • Posts: 76037
    • >>>  Avast Forum - Deutschsprachiger Bereich  <<<
Re: AVAST causes VBA issue in MS Access
« Reply #1 on: June 01, 2021, 09:54:52 AM »
W8.1 [x64] - Avast Free AV 23.3.8047.BC [UI.757] - Firefox ESR 102.9 [NS/uBO/PB] - Thunderbird 102.9.1
Avast-Tools: Secure Browser 109.0 - Cleanup 23.1 - SecureLine 5.18 - DriverUpdater 23.1 - CCleaner 6.01
Avast Wissenswertes (Downloads, Anleitungen & Infos): https://forum.avast.com/index.php?topic=60523.0

Offline siewhoon

  • Newbie
  • *
  • Posts: 9
Re: AVAST causes VBA issue in MS Access
« Reply #2 on: June 01, 2021, 10:04:41 AM »
Thanks Asyn!
I have tried the Blocked & Allowed Apps but it didn't resolve the issue.
Is there any other way??

Offline Asyn

  • Avast Überevangelist
  • Certainly Bot
  • *****
  • Posts: 76037
    • >>>  Avast Forum - Deutschsprachiger Bereich  <<<
Re: AVAST causes VBA issue in MS Access
« Reply #3 on: June 01, 2021, 10:07:17 AM »
I have tried the Blocked & Allowed Apps but it didn't resolve the issue.
Did you reboot afterwards..!?
W8.1 [x64] - Avast Free AV 23.3.8047.BC [UI.757] - Firefox ESR 102.9 [NS/uBO/PB] - Thunderbird 102.9.1
Avast-Tools: Secure Browser 109.0 - Cleanup 23.1 - SecureLine 5.18 - DriverUpdater 23.1 - CCleaner 6.01
Avast Wissenswertes (Downloads, Anleitungen & Infos): https://forum.avast.com/index.php?topic=60523.0

Offline siewhoon

  • Newbie
  • *
  • Posts: 9
Re: AVAST causes VBA issue in MS Access
« Reply #4 on: June 01, 2021, 10:39:19 AM »
Yes, I did reboot.  Now, my other colleagues who downloaded Avast Premium Security are also laden with the same issue.
We may all have to uninstall it, if we can't resolve in a day or two.

Thanks, Asyn, for your quick response.

Offline Asyn

  • Avast Überevangelist
  • Certainly Bot
  • *****
  • Posts: 76037
    • >>>  Avast Forum - Deutschsprachiger Bereich  <<<
Re: AVAST causes VBA issue in MS Access
« Reply #5 on: June 01, 2021, 10:54:51 AM »
- Which version/build of Avast Premium..?
- OS..? (32/64 Bit..? - which SP/Build..?)
- Other security related software installed..?
- Which AV(s) did you use before Avast..?
W8.1 [x64] - Avast Free AV 23.3.8047.BC [UI.757] - Firefox ESR 102.9 [NS/uBO/PB] - Thunderbird 102.9.1
Avast-Tools: Secure Browser 109.0 - Cleanup 23.1 - SecureLine 5.18 - DriverUpdater 23.1 - CCleaner 6.01
Avast Wissenswertes (Downloads, Anleitungen & Infos): https://forum.avast.com/index.php?topic=60523.0

Offline siewhoon

  • Newbie
  • *
  • Posts: 9
Re: AVAST causes VBA issue in MS Access
« Reply #6 on: June 01, 2021, 11:48:56 AM »
This is the info :
AVAST Premium Security version 21.4.2464 (Build 21.4.6266.668)
OS - 64-bit, Windows 10 vers 2004
No other security related software installed
Previous AV - McAfee

It will be great if we could solve this soon.  Thank you again, Asyn!

Offline Asyn

  • Avast Überevangelist
  • Certainly Bot
  • *****
  • Posts: 76037
    • >>>  Avast Forum - Deutschsprachiger Bereich  <<<
Re: AVAST causes VBA issue in MS Access
« Reply #7 on: June 01, 2021, 11:56:23 AM »
Do you get any warning msg from Avast..!?

If yes, please post a screenshot.
If no, see if you find any hint in the report files. -> C:\ProgramData\AVAST Software\Avast\report
W8.1 [x64] - Avast Free AV 23.3.8047.BC [UI.757] - Firefox ESR 102.9 [NS/uBO/PB] - Thunderbird 102.9.1
Avast-Tools: Secure Browser 109.0 - Cleanup 23.1 - SecureLine 5.18 - DriverUpdater 23.1 - CCleaner 6.01
Avast Wissenswertes (Downloads, Anleitungen & Infos): https://forum.avast.com/index.php?topic=60523.0

Offline siewhoon

  • Newbie
  • *
  • Posts: 9
Re: AVAST causes VBA issue in MS Access
« Reply #8 on: June 01, 2021, 12:05:00 PM »
No warning msg from Avast.
C:\ProgramData\AVAST Software\Avast\report - what will tell me something is amiss?
I see several lines of Shield Started... Shield Stopped...

Offline Asyn

  • Avast Überevangelist
  • Certainly Bot
  • *****
  • Posts: 76037
    • >>>  Avast Forum - Deutschsprachiger Bereich  <<<
Re: AVAST causes VBA issue in MS Access
« Reply #9 on: June 01, 2021, 12:11:28 PM »
Hi, beats me, but I forwarded it, let's see...
W8.1 [x64] - Avast Free AV 23.3.8047.BC [UI.757] - Firefox ESR 102.9 [NS/uBO/PB] - Thunderbird 102.9.1
Avast-Tools: Secure Browser 109.0 - Cleanup 23.1 - SecureLine 5.18 - DriverUpdater 23.1 - CCleaner 6.01
Avast Wissenswertes (Downloads, Anleitungen & Infos): https://forum.avast.com/index.php?topic=60523.0

Offline siewhoon

  • Newbie
  • *
  • Posts: 9
Re: AVAST causes VBA issue in MS Access
« Reply #10 on: June 01, 2021, 12:33:26 PM »
Thank you very very much for helping me find a solution.
Keeping my fingers crossed for an easy way out.

Offline PDI

  • Avast team
  • Full Member
  • *
  • Posts: 159
Re: AVAST causes VBA issue in MS Access
« Reply #11 on: June 01, 2021, 12:40:14 PM »
Hi siewhoon,

did you try to disable some shields to find the culprit?

Could you please create a support package and provide us the support package ID to investigate the issue?

Thanks a lot,
PDI

Offline kwiq

  • Avast team
  • Sr. Member
  • *
  • Posts: 254
Re: AVAST causes VBA issue in MS Access
« Reply #12 on: June 01, 2021, 12:42:48 PM »
Hi siewhoon,
i would suggest disabling avast shields one by one to see which one is responsible.
My guess is file shield of amsi but it is hard to tell.

Can you create a procmon log and send it to analysis :
1) download procmon from https://docs.microsoft.com/en-us/sysinternals/downloads/procmon
2) run is as admin
3) induce the issue
4) save procmon log (menu -> File -> Save..., All events, Native  procmon format) as siewhoon_vba_procmon_6_2021.pml
 and upload it to avast ftp server(https://support.avast.com/en-eu/article/FTP-file-upload )

Thanks for report !

Offline siewhoon

  • Newbie
  • *
  • Posts: 9
Re: AVAST causes VBA issue in MS Access
« Reply #13 on: June 01, 2021, 12:51:22 PM »
Thanks for providing steps.  I'm knocking off now and, will attempt this tomorrow.
Hopefully, the issue becomes history tomorrow.

Thanks guys!

Offline john2122

  • Newbie
  • *
  • Posts: 8
Re: AVAST causes VBA issue in MS Access
« Reply #14 on: June 01, 2021, 05:38:42 PM »
Hello,

I'm a programmer myself and I must say that initially I also had some trouble with Avast. But everything is running smoothly now, after some config in Avast.

Especially Visual Studio + Avast gave us some headaches  ;)  Mostly because Avast proactively kept scanning (and sometimes blocking & vaulting) the newly compiled files when building the solution or debug-running them, which basically prevented me from testing and executing my assemblies/solutions. Plus, it sometimes totally messed up the solution as a whole, because important files went missing (moved to the vault).

I also had some issues with VBA in Excel, but we do not code VBA in Access (we only use MSSQL Server for DB projects). So, unfortunately I can't comment on that. Although the symptoms are likely similar.

Anyway, all issues, including those with Excel macro enabled files (VBA), were basically solved by adding the appropriate files/folders to exceptions in Avast. For VS that mostly meant the Build and Publish folders (or the Project folder as a whole, but I thought that to not be the safest solution). I did not add any Blocked & Allowed Apps. I only used File/folder Exceptions: go to Menu > Settings > General > Exceptions > add files/folders there as required.

I hope this helps?

I must admit, though, that I am not sure if adding macro enabled MS Office files and executables, even trusted ones, to exceptions in Avast is practical and/or even wise. They can also still become infected after all! Are there any "best practices" documents or other advisories available from Avast for situations like these? That would probably help a lot of people, including the OP?