New ODBC Link in Access

My DSN has already been setup on my machine. I want to delete a table and
then relink it with ODBC in Microsoft Access? I only know how to
RefreshLink and Delete a table. Using VB6 how do I create a new linked
table?

--

Please reply to the group so all can benefit.
Any help would be greatly appreciated.
Mel

You add a new TableDef object, and set its Connect property.

While aimed at Access programmers,
<a style='text-decoration: underline;' href="http://www.mvps.org/access/tables/tbl0010.htm" target="_blank">http://www.mvps.org/access/tables/tbl0010.htm</a> at "The Access Web" is an
example of how to relink ODBC tables from code.

--
Doug Steele, Microsoft Access MVP
<a style='text-decoration: underline;' href="http://I.Am/DougSteele" target="_blank">http://I.Am/DougSteele</a>
(No private e-mails, please)



"Mel" <mel.RemoveThis@circuitcheck.comM> wrote in message
news:%23uJ8VCE3DHA.3216@TK2MSFTNGP11.phx.gbl...
 > My DSN has already been setup on my machine. I want to delete a table and
 > then relink it with ODBC in Microsoft Access? I only know how to
 > RefreshLink and Delete a table. Using VB6 how do I create a new linked
 > table?
 >
 > --
 >
 > Please reply to the group so all can benefit.
 > Any help would be greatly appreciated.
 > Mel
 >
 ><!-- ~MESSAGE_AFTER~ -->