Linked Table Manager Question

[Guest]

For some reason, whenever I use the LTM (Link Table Manager) and I select the
box located at the left bottom corner, it goes through each table that I
select and makes me define where the new table needs to come from. It use to
not work this way. Before, I would just define a single mdb and it would
update all the links to the table I just defined. I want to be clear that the
new mdb file that I point to DOES contain each and every table that I checked
in the LTM. For some reason, if there are 50 tables, then I prompts me to
define 50 mdb files where it can find the table... even though all 50 tables
comes from the same mdb file.

Does anyone else have this problem? It used to work quickly. Now I must
navigate through a harendous path for each and every one of the table I want
to relink.

Any thoughts? Much appreciated. Thanks in advance.

 

[rwr]

For some reason, whenever I use the LTM (Link Table Manager) and I select the
box located at the left bottom corner, it goes through each table that I
select and makes me define where the new table needs to come from. It use to
not work this way. Before, I would just define a single mdb and it would
update all the links to the table I just defined. I want to be clear that the
new mdb file that I point to DOES contain each and every table that I checked
in the LTM. For some reason, if there are 50 tables, then I prompts me to
define 50 mdb files where it can find the table... even though all 50 tables
comes from the same mdb file.

Does anyone else have this problem? It used to work quickly. Now I must
navigate through a harendous path for each and every one of the table I want
to relink.

Any thoughts? Much appreciated. Thanks in advance.

Generally this is the result of an error occurring during a relinking
and the table link manager sees two different paths to the tables in
your db. When you open the Link Manager, look at the path for each
table, you should see 2 or more different paths.

Don't do a select all. select all of the tables related to one of the
path definitions and link them in, then select the tables related to the
other path and repeat the linking process. You will need to do this as
many times as you have different paths linking your tables.


HTH,
Ron

 

[Jeff Boyce]

I've only seen this happen when I had (at least) one link that was different
than the rest.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/