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.
Retrieving data ...