search

joyfullservice / msaccess-vcs-addin

Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.
Other
211 stars 41 forks source link

No MSysIMEXSpecs and MSysIMEXColumns tables present in Version Control.accda #33

Closed cenx1 closed 4 years ago

cenx1 commented 4 years ago

Systeminfo

Details

The project that I am building contains Import/Export Specifications (I think they are called that) and when I am building from source, the step that import the two MSys tables MSysIMEXSpecs and MSysIMEXColumns from Version Control.accda into the new project that it is building, fails because the tables are not present in the add-in.

The error happens in the clsDbImexSpec module in this function:

Private Sub ImportMissingTableFromAddIn(strTable As String)
    If Not TableExists(strTable) Then
        ' This is were the problem is
        DoCmd.TransferDatabase acImport, "Microsoft Access", CodeProject.FullName, acTable, strTable, strTable, True
    End If
End Sub

The Version Control add-in should contain the two tables upon release.

joyfullservice commented 4 years ago

Beautiful job reporting this issue! Thanks for taking the time to document this clearly. I was able to push a code change this morning (806e990) that should fix the issue with the missing tables.