Refresh SQL database links in Access

[Beatrice]

I am linking SQL tables in Access. How can I run a macro
to drop tables then relink them or just refresh my links?
If I have to code it, do I put it in a Module? Then I need
to know in the code what I need to replace with mine by
underling the words.

 

[Alex Dybenko]

here a sample:
http://www.mvps.org/access/tables/tbl0010.htm

 

[Duane Hookom]

I can't image trying to do this with a macro. Doug Steele has some code and
other information at
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html.