linked table manager

message from =?Utf-8?B?VklDVE9S?= on 3 Jun 2004
í 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
 
Arvin Meyer replied to =?Utf-8?B?VklDVE9S?= on 3 Jun 2004
automatically, i mean by a macro or something.

Have a look at this post on the Access Web:

http://www.mvps.org/access/tables/tbl0009.htm
 
=?Utf-8?B?VklDVE9S?= replied to Arvin Meyer on 4 Jun 2004
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
 
Arvin Meyer replied to =?Utf-8?B?VklDVE9S?= on 4 Jun 2004
2000) User_defined type not defyned.

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.
 

Archived message: linked table manager (MS Access)