For anyone looking to do this, finally got it to work with this!
Function createAttached(strTable As String, strPath As String, strBaseTable As String) As Boolean
'************************************************************************************
'* Create an attached table in the current...
I did not have it, would this replace Option Compare Database? My apologies if this is a silly question. new to VBA and self taught
In addition, to avoid confusion I also forgot to remove a few old variables that I had been trying before (strPrefix, strNewConnection)
Hi so I have a database that links to one main backend, however, one of the tables will become incredibly large(contains mass amounts of financial data) and I would like to link this table to a separate database.
On our main menu the user selects the particular fund that they will be working on...