Linked tables tip

[rogerarce]

Hello.

I have 2 databases in the same directory. One has a linked table. Everytime I need open the one with the linked table I have to go to the linked table manager. I would like to avoid
using the manager; is there a way to do it with just one button click?

DB1 c:\inventory\inventory1
DB2 c:\inventory\invoice (linked table here)

Thanks in advance for you help and for sharing your knowledge.

Roger

 

[MajP]

Everytime I need open the one with the linked table I have to go to the linked table manager

Can you explain why you have to go to the manager? You should be able to open a db with a linked table without problem.

I have code to relink tables, but you need to be proficient in VBA it is not simple. How is your coding?