Refresh ODBC/DNS Linked tables In Access 2000

  • Thread starter Thread starter Charles
  • Start date Start date
C

Charles

Hi All Access Gurus,

Don't konw where my quiz goes so post it twice.

I am using Access 2000. In file I have several ODBC/DNS tables linked
to remote SQL Server 2000 server.

What I need:

When user click a button, all these linked tables will get refreshed.
That's it.

Could anybody tell me how to implement this in VBA??

Any suggestion would be highly appreciated.

Charles
 
A linked table is kept up to date by definition. I'm not
certain on the exact mechanism by which this is
accomplished, but whenever you query or open a linked
table you'll have access the most recent data stored in
the table. There should be no need for additional VBA
code, unless you are exporting data.
 
Back
Top