creating a macro for refreshing a linked table?

[ro]

i created a linked table using linked table manager and
was wondering is there's a way to create a macro that can
refresh the table every time i open the database?

thanks in advance.

 

[Douglas J. Steele]

Not using a macro, but fairly easy using VBA.

See http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" for
one approach (or http://www.mvps.org/access/tables/tbl0010.htm if you're
connecting using ODBC)