Version Control Menu Option disappeared.

[jeffdombach]

The Version Control option disappeared from my menu. When I check Add-Ins, it is available to be installed. When I click Install, I get an error "The add-in could not be installed because it is missing a USysRegInfo table."

[joyfullservice]

This add-in has built-in installer, which you can run by downloading and opening the add-in file. The Access add-ins that you were looking at is a different way to install add-ins, and not compatible with this particular add-in.

You can find installation instructions on the wiki.

Hope that helps!

[jeffdombach]

I re-ran the built in installer and it is still missing from the menu.

[joyfullservice]

Sorry for the difficulty there. In my experience, reinstalling usually fixes this kind of issue. (Make sure to close all instances of Microsoft Access, including any hidden processes, before installing.)

I assume you are installing the latest version of the add-in. Which version of Access are you using? (I.e. 2019, 365, etc...) Also, do you see the ribbon after installing the add-in? The ribbon is technically a COM add-in, and can be found in Options -> COM Add-ins.

Has it worked in the past, and just suddenly stopped working, or are you installing it for the first time? If you are in a corporate environment with higher restrictions on your computer, you can check out this link for some more technical specifics.

Let me know how it goes!

[jeffdombach]

I had installed several months ago and I absolutely love using the VCS add-in. I can see the COM Add-In. When I click the checkbox and restart Access, still no sign of VCS in the menu. Using Version_Control_v4.0.34.zip

[joyfullservice]

Hmm... I don't have that version of Access to test, but maybe we could try manually removing the add-in files, and reinstalling. It is also possible that an Access "update" broke something, but hopefully not... 🤔

To manually remove the files, you can press WIN+R and enter %appdata% in the box. Click run, then navigate to the MSAccessVCS folder and delete the following files:

• Version Control.accda
• MSAccessVCSLib_win64.dll
• Ribbon.xml

Then run the install again, (making sure you have extracted the add-in from the zip file) and see if that fixes it.

If that still doesn't fix it, (but the files are installed in the correct location) then you can use another method to load the add-in. (The goal here is to get to the options screen so we can run the uninstall, which will remove DLL registrations and other registry entries as well for a clean uninstall.)

Paste the following into a standard module in any database, and run the function.

Public Function ExampleLoadAddInAndShowOptions()

    Dim strAddInPath As String
    Dim proj As Object      ' VBProject
    Dim objAddIn As Object  ' VBProject

    ' Build default add-in path
    strAddInPath = Environ$("AppData") & "\MSAccessVCS\Version Control.accda"

    ' See if add-in project is already loaded.
    For Each proj In VBE.VBProjects
        If StrComp(proj.FileName, strAddInPath, vbTextCompare) = 0 Then
            Set objAddIn = proj
        End If
    Next proj

    ' If not loaded, then attempt to load the add-in.
    If objAddIn Is Nothing Then

        ' The following lines will load the add-in at the application level,
        ' but will not actually call the function. Ignore the error of function not found.
        ' https://stackoverflow.com/questions/62270088/how-can-i-launch-an-access-add-in-not-com-add-in-from-vba-code
        On Error Resume Next
        Application.Run strAddInPath & "!DummyFunction"
        On Error GoTo 0

        ' See if it is loaded now...
        For Each proj In VBE.VBProjects
            If StrComp(proj.FileName, strAddInPath, vbTextCompare) = 0 Then
                Set objAddIn = proj
            End If
        Next proj
    End If

    If objAddIn Is Nothing Then
        MsgBox "Unable to load Version Control add-in. Please ensure that it has been installed" & vbCrLf & _
            "and is functioning correctly. (It should be available in the Add-ins menu.)", vbExclamation
    Else
        ' Launch add-in and show options
        Application.Run "MSAccessVCS.HandleRibbonCommand", "btnShowOptions"
    End If

End Function

If the options window loads, then click the button to uninstall the add-in.

After this, try installing again and see if it works normally after that.