linked table manager

Ã* want to know if there is a way to refresh the linked table automatically, i mean by a macro or something.
and how can a i make this, thanks for your answers

"VICTOR" wrote in message
...
í want to know if there is a way to refresh the linked table
automatically, i mean by a macro or something.
and how can a i make this, thanks for your answers

Have a look at this post on the Access Web:

http://www.mvps.org/access/tables/tbl0009.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Excuse me, where do i need to put the code (fRefreshLinks) to run it ?
I´ve inserted it in a module and appears a Compile error (i´m using acces 2000) User_defined type not defyned.
I hope that you can help me because i´ve used access just a few times

"VICTOR" wrote in message
...
Excuse me, where do i need to put the code (fRefreshLinks) to run it ?
I´ve inserted it in a module and appears a Compile error (i´m using acces
2000) User_defined type not defyned.
I hope that you can help me because i´ve used access just a few times

Remember to also include GetOpenFileName:

http://www.mvps.org/access/api/api0001.htm

and put it in a module, or you will have errors. Make sure you read all the
instructions that go with both of them.

I happened to test these 2 modules last Monday, unaltered and directly from
the web pages. I put a command button on the opening form and set its Click
property to:

= fRefreshLinks()

And it ran perfectly in both Access 97 and 2002.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access