Refresh Linked Tables button (1 Viewer)

[chris_visible]

Hi

Is it possible to code a button that opens the linked table manager? Ideally I would like it to automatically ask for the location of all tables. I.e. tick every box on the first dialog.

I would be very grateful if someone knew how to do this because I have tried many long-winded ways of creating this button and nothing seems to work.

Many Thanks

 

[jatfill]

I've done this with success on a DB I use at home...
http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q209862