Linked table - Source change

[Bret]

Please,
Searching for a reference or help in using CODE to automatically changes the
source SQL database for all my linked tables. I know how its done manually
but need to do it in the modules.

thank you.

 

[Douglas J. Steele]

Do you mean you want to change the SQL Server database to which your tables
are pointed?

If you're using a DSN, check http://www.mvps.org/access/tables/tbl0010.htm
at "The Access Web" for one approach. Or, if you prefer not to use DSNs,
take a look at what I have at
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html

 

[Michel Walsh]

Hi,


If you mean using T-SQL with MS SQL Server, take a look at "Linked
Servers" (and sp_addlinkedserer) , OPENQUERY, OPENROWSET and
OPENDATASOURCE. Use the linked server if you plan to use the data
frequently.

With Jet, use DAO, the object TableDef hold a property Connect that hold
the location of the data (among other things). You have to use the method
RefreshLink to "kick" the change you bring to the Connect property.



Hoping it may help,
Vanderghast, Access MVP