Refresh Table Links With VBA

[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!

 

[Daniel Pineault]

For ODBC tables take a look at http://www.mvps.org/access/tables/tbl0010.htm
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[Douglas J. Steele]

I much prefer going DSN-less. See
http://www.accessmvp.com/DJSteele/DSNLessLinks.html

 

[Daniel Pineault]

Thank you for that Douglas! I wasn't even aware you could do this.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[Jordan C. Schroeder]

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.

 

[Douglas J. Steele]

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.