Updates the connection information for a linked table (Microsoft Jet workspaces only).
Syntax
VOIDRefreshLink(VOID);
Remarks
To change the connection information for a linked table, reset the Connect property of the corresponding CdbTableDef object and then use the RefreshLink method to update the information. Using RefreshLink method doesn't change the linked table's properties and CdbRelation objects.
For this connection information to exist in all collections associated with the CdbTableDef object that represents the linked table, you must use the Refresh method on each collection.
Usage
#include <afxole.h>
#include <dbdao.h>
CdbTableDef td;
...
td.SetConnect(_T("Excel 8.0;drive:\path\filename.xls"));
td.RefreshLink();