none
Cannot open VBA project in any files or make design changes to forms RRS feed

  • Question

  • Windows version 1803 build 15134.472
    MS Access 2016 MSO (16.0.9126.2315) 32-bit

    The day before yesterday I was not able to make changes to forms, even in a fresh database, but I had no problem viewing code in existent databases. An online repair through programs and features did not resolve it. Yesterday I lost the ability to view code, also. If I create a blank database, a form, then through form properties attempt to view code for an event, I get the following error:

    Microsoft Access is unable to load the Visual Basic for Applications dynamic-link library (DLL) Vbe7.
    Rerun the Microsoft Access Setup program.

    I did an online repair several times. I cannot uninstall Office 365 Pro Plus because it is pushed out to my machine, and if I uninstall I don't have the media to put it back. I have admin rights on the machine

    From another machine I replaced files at  C:\Program Files (x86)\Microsoft Office\root\vfs\ProgramFilesCommonX86\Microsoft Shared\VBA. Inside there were folders VBA6 and VBA7.1. The replacement had the same folders but an earlier date for VBE7.DLL and different file contents. A subsequent online repair rewrote these again.

    I have no idea how to fix this, except to have my machine wiped and reinstall all software, which would be a pain and seemingly unnecessary.

    Due to the many versions of MS Access we have, development and maintenance to apps is still done using Access 2000 with compiled MDE files deployed. They open and run fine in whatever version the user has. Occasionally when work needs to be done on an ACCDB file, we use Access 16 for that. Office 365 is installed first, then Office 2000, choosing only access within that. Since Office 365 is universal now in our organization we plan to bring everything forward to that. Upon experiencing this problem I uninstalled Access 2000 and did an online repair of Office 365 Pro Plus to no avail.

    Just now I logged off from my normal domain user on the machine and logged in with a local user ID having admin rights. I had no issues with MS Access at all, could change forms, and could go immediately to code. From that user I cleaned temp files from my main user. This made no difference. If I have to I can delete the main user and recreate again, which would be better than wiping the machine, but I would lose all my configurations. I would like to know why the problem exists for the user I have in case it ever happens again.


    • Edited by dmcdivitt Thursday, January 17, 2019 2:56 PM
    Thursday, January 17, 2019 2:46 PM

All replies

  • Main message was edited with the last paragraph added.
    Thursday, January 17, 2019 2:57 PM
  • Hi,

    Not sure if this is applicable to your scenario but it isn't rare to have a user's profile become corrupted, with the only solution being to create a new user profile.

    Just my 2 cents...

    Thursday, January 17, 2019 4:14 PM
  • Uninstalling O365 shouldn't pose an issue since you can reinstall it from the web console.  You log into your O365 account and you can install it, no media necessary.

    Normally, the recommended installation sequence is always to install the older version first followed by the newer version.  Moreover, it is even better to segregate version by using VMs.

    As for uninstalling O365, always use Option 2 from https://support.office.com/en-us/article/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8

    Have you tried manually updating, or reverting your build no to see if it is a bug with your specific build?
    Is your O365 activated properly?


    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Thursday, January 17, 2019 4:20 PM
  • Yes, O365 is activated OK. I cannot separate out versions or roll back. I was thinking maybe an update came through causing the problem, but it works fine when logged in as a different user.
    Thursday, January 17, 2019 4:54 PM
  • In that case, have you tried theDBguy's suggestion regarding a corrupted profile?  Try recreating the profile (backup everything first!).

    Daniel Pineault, 2010-2018 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Thursday, January 17, 2019 5:55 PM
  • I am sure recreating the profile will work because no problem exists with a different user name. I don't want to unless I must.
    Thursday, January 17, 2019 5:58 PM