The creation and customization of database applications using Microsoft Access
Hello @Irene Wu
Thank you for providing the screenshot of the error. The message:
“Microsoft Access is unable to load the Visual Basic for Applications dynamic-link library (DLL) Vbe7.”
indicates that Access is encountering an issue loading the VBA component. Therefore, I would first like to determine whether the problem lies with the Office/VBA installation or with the legacy database itself.
On one of the affected machines, please try the following:
-Create a new, blank Access database > Go to "Database Tools" > "Visual Basic" > Check if the same "Vbe7" error appears.
If the new database also triggers the error, please try performing an "Online Repair" of Office on a test machine and check again.
If VBA works correctly in a new database but the error only occurs in your legacy database, please first create a backup of that database. One potential workaround for Access issues involving "Vbe7.dll" is to "decompile" and then "recompile" the database. However, as that documentation relates to an older issue with Access 2010, I strongly advise testing this only on a copy of the database, never on your production database.
Additionally, could you please provide the following information?
- Is your version of Office LTSC 2024 32-bit or 64-bit?
- Does the error also occur in a blank database?
- Does the error appear on all machines following the update, or only on some?
Since you have confirmed that VBA works on version 16.0.17932.20976 but fails on several newer builds, knowing whether the issue can be reproduced in a blank database would be crucial for distinguishing between a problem specific to your legacy database and an issue with Office/VBA itself following the update.
Please note that I am a fellow community user, not a Microsoft employee; therefore, I cannot confirm whether this is a known regression that has been officially documented by Microsoft.