Link tables

[AM]

What is the difference in linking a table with VBA and
linking a table with File|Get External Data|Link Tables?
I want to place forms, queries etc on a few local machines
and have the data on a network drive. I have seen code
that will link tables but wouldn't linking the tables
through the menu work just as well?

 

[Mark]

In a front end/back end situation, the only advantage I
can see to link tables with VBA is that it allows you to
connect tables without the user being aware that it is
happening. Connecting temporary tables to avoid bloating
would be one reason to do it.

Mark