Search results

  1. R

    dynamically link tables to multiple backends

    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...
  2. R

    dynamically link tables to multiple backends

    good to know, thanks! i added that but still nothing seems to be happening
  3. R

    dynamically link tables to multiple backends

    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)
  4. R

    dynamically link tables to multiple backends

    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...
Top Bottom