Linked Tables

A

Andrew

Hi,

2 questions about linking tables...

1 - When you link a table is the size of it included in the current database?

2 - Everytime you open the current database does it get the latest version
of the table form the source?
 
D

Dirk Goldgar

In
Andrew said:
Hi,

2 questions about linking tables...

1 - When you link a table is the size of it included in the current
database?
Click to expand...

No. Some information about the linked table is held in the current
database, but none of the data is held there, so the size of the table
is irrelevant in the current (linking) DB.
2 - Everytime you open the current database does it get the latest
version of the table form the source?
Click to expand...

Well, yes and no. The data from the table is brought from the linked,
source database as requested, so it's always up to date. I believe,
though, that if some aspects of the design of the table are changed in
the source database, the descriptive information about that table, which
is stored in the current database as I mentioned above, may be incorrect
and can lead to odd behavior. Therefore, if you change the design of a
linked table in the source database, you ought to refresh the links in
the current database to make sure that information is up to date.
 
T

Tom Wimpernads

Andrew

linked tables are no longer reccomended; you should be using Access Data
Projects

keep all your tabels and queries in ONE PLACE-- where they belong-- on a
database server
 
D

Dirk Goldgar

In
Tom Wimpernads said:
linked tables are no longer reccomended; you should be using Access
Data Projects
Click to expand...

This is false information. Whatever you may feel about the relative
merits of ADPs vs. MDBs or ACCDBs, Microsoft is currently recommending
linked tables over ADPs.
 
Top