DAO External: Refreshing and Removing Links

  • Article

|  Overview |  How Do I |  FAQ |  Sample |  |  ODBC Driver List

This article explains how to refresh or remove a link to an attached table when the table has moved. For background, see the article DAO External: Attaching External Tables.

To refresh a link

  1. Reset the table's connection information ? that is, change the path to the external data source.

    Call the member function for the saved tabledef object representing the attached table.

  2. Call the tabledef object's member function.

To remove a link to an attached table

  • In the object for your Microsoft Jet (.MDB) database, call the member function. Specify the name of the external table (the tabledef name).

Important   When you  delete an attached table, only the link is deleted. The external table itself is unaffected.

See Also   DAO: Where Is..., DAO External: Working with External Data Sources, DAO External: Attaching External Tables, DAO External: Creating an External Table