Microsoft Access 2003 - Linked Table Manager

Question

Is it possible to reset multiple linked tables using the Linked Table Manager? It seems it can only do one at a time. Thanks.

Answer 1

There's a file Refresh.zip in my public databases folder at:

http://cid-44cc60d7fea42912.skydrive.live.com/redir.aspx?resid=44CC60D7FEA42912!169

which includes demonstration databases for automatically detecting invalid links at start-up in both single of multiple back-ends.  In the case of the latter a multi-select list box shows which links are  broken and allows multiple items to be selected to browse to and refresh the links for each subset of tables.

Answer 2

Greetings - All the linked files are contained in one .mdb. When I select all, I am prompted for each table to provide the path. I was hoping that once I chose the first table path, it would know to use that path for the rest of the tables.

 

Thanks.

Hmmm, I have experienced that, but usually when there are multiple sources for linked tables.

Answer 3

Greetings - All the linked files are contained in one .mdb. When I select all, I am prompted for each table to provide the path. I was hoping that once I chose the first table path, it would know to use that path for the rest of the tables.

Thanks.

Answer 4

You can select all or select multiple tables. However, if you select tables from different files, then Access prompts you for the location of each table. So if you are linking to different files, only select tables from the same file and you should be able to identify the location once.