none
MS Access Linked Tables Connection String Save in Table DSN Less RRS feed

  • Question

  • We have many MS Access databases with linked tables.

    We want to store the link (connection properties) in a database, and upon login, restore the links.

    Some of the links are ODBC with DSN name, some are other Access databases, some to Excel spreadsheets.

    We want to remove the DSN, and have server name, database name, table name.

    When I place my mouse cursor over the linked table I get something like:

    ODBC;DSN=nameofdsn;SERVER=servername;;TABLE=tablename

    When I go into design view of the table and look at the properties, for Description I see the same string.

    However when I use the Connect property of the TableDef object I do not see the table name.

    I see: ODBC;DSN=nameofdsn;SERVER=servername;

    I don't want to assume that the name of the linked table is actually the name of the back end table, probably is, but not certain.

    I tried returning the description property of the TableDef object, i.e. tbl.Description, but that is invalid.

    How could I get the table name and store it in the table along with server and database name?

    Thanks

    Thursday, March 29, 2018 8:38 PM