I have a frontend dbs, backend dbs, and another separate database (editStructure dbs) which updates the backend as needed.
I user only opens the frontend
I need the frontend to check to see if the editStructure dbs exists and if it does open it and run the RunUpdate macro. All while the user is oblivious to this happening.
The RunUpdate macro will execute code which will do something (in this case change a field name to correct a spelling mistake)
I have attached the code used to open the editStructure dbs as needed.
How do I execute the macro RunUpdate (located on EditStructure dbs)?
Function OpenDatabaseRunUpdate(strDbPath As String, strMacroName As String)
Dim wrkJet As Workspace
Dim dbs As Database
Dim tbl As TableDef
Dim fld As Field
' Create Microsoft Jet Workspace object.
Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)
' Open Database object from saved Microsoft Jet database
' for exclusive use.
Set dbs = wrkJet.OpenDatabase(strDbPath, True, False)