Link tables

A

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?
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top