Update linked tables by program

[inoxo]

To update the links to tables (e.g. on a server), I use the linked table manager.

I would like to update the links otherwise : with a procedure.
So I could execute it when opening the main form of my client.

Code gives as an example would be the welcome !

Thanks.

 

[RuralGuy]

Maybe this link will help.

 

[inoxo]

Many thanks. The code looks fine.

However, when I have both linked tables and "normal" tables in my database, the code should try to link only the tables who are linked, not the other ones.

Is there any mean to distinguish linked tables from "normal" tables ?

 

[RuralGuy]

I have not tried the code. Are you saying it tries to link tables that are *not* linked tables? By *Normal Tables* do you mean local tables, tables internal to the mdb? I believe those tables do *not* have a .Connect string and the code is testing for 1 space with: If db.tabledefs(i).connect <> " " Then. Maybe it should be looking for zero length string instead (""). Something tells me if this code had a problem, it would have been fixed ages ago.