Using VBA to manage remote table links 2

[mac318]

Would someone please explain the technique(s) used to manage table and stored SQL links to remote database(s) using code. I know it's available through the Export/Import/Link menu; however, there must also be a method for using code to add, delete, and change these links once established.

Thanks,

mac(318)

 

[tlbroadbent]

Check these links.

ACC: How to Create a Customized "Attach ODBC Table" Form

http://support.microsoft.com/support/kb/articles/Q128/8/78.ASP

Establishing Access to External Data

http://msdn.microsoft.com/library/en-us/office97/html/establishingaccesstoexternaldata.asp

How to Relink Back-End Tables with Common Dialog Control

http://support.microsoft.com/support/kb/articles/Q181/0/76.ASP

http://support.microsoft.com/support/kb/articles/Q209/8/62.ASP

Creating a Linked Table

http://msdn.microsoft.com/library/en-us/odeopg/html/deovrcreatinglinkedtable.asp

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[mac318]

Terry, thank you so very much for articles. They are precisely what I need.

mac