Has anyone tried opening a mdb Access database through VB6. Below is the following code which i am using unfortunately i get a "can't open external database" error
DBOpenStatus = MonarchObj.OpenDatabase("C:Test DataMonarchMonarch FilesExportClient.mdb", "", "Untitled", "C:Test DataMonarchMonarch FilesModelsclient.mod")
Any help much appreciated.
Also is it possible once the table is opened in Monarch to then join another table to it using VB6 to automate it.