Refresh Table Links With VBA

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

Hello,

I am simply looking for an example of how to automatically refresh tables
that are linked to SQL Server. Everything I have found so far deals with
Access to Access linkage. If any of you experts could provide a sample, it
would be greatly appreciated.

Thanks!
 
Hello and thank you both for your quick replies. Something I failed to
mention in the post is that I have linked tables to different servers that
need the refreshing. Is it possible to update the links to both servers at
the same time with either of the examples? Thanks again for the help.
 
It's possible, but not without changes to either example.

In a nutshell, the value to which you'll be setting the Connect property
will depend on which table it is. You'll have to add logic to determine what
the correct value is for each table.
 
Back
Top