J
Jay
Greetings all:
I have an access (97) database with many tables linked
from SQL Server 2000 via a DSN. At one point months ago I
found some VBA that would whip through and relink all the
tables to a new DSN. I cannot currently find that code,
and I'm going quite mad looking for it.
Does anyone have code to do this? I don't want the code
that MS has on their site of building a table of
information, etc., etc., I simply need to go through each
table that is an odbc connection and update to a new DSN.
Any help is greatly appreciated.
Jay
I have an access (97) database with many tables linked
from SQL Server 2000 via a DSN. At one point months ago I
found some VBA that would whip through and relink all the
tables to a new DSN. I cannot currently find that code,
and I'm going quite mad looking for it.
Does anyone have code to do this? I don't want the code
that MS has on their site of building a table of
information, etc., etc., I simply need to go through each
table that is an odbc connection and update to a new DSN.
Any help is greatly appreciated.
Jay