Error when using TransferDatabase
I get a run time error '2507', "The type isn't an installed database type or doesn't support the operation you chose.", when trying to execute the following code:
DoCmd.TransferDatabase acLink, , strDatabaseName, , "tblLogShip", "tblLogShip"
My desire is to link the table "tblLogShip", which is contained in another .mdb database whose name is contained in the variable strDatabaseName. I have checked and rechecked all of the variables at run-time and can't find anything amiss. Anyone else come up against this?