Do linked tables update automatically?

[Guest]

I have linked several tables from one database into another. I have also
done a query using the existing & the linked tables. I will do a report
using the linked tables as well.

If a user enters new records or modifies existing records in the other
database, will these changes be automatically visible when I run the query or
report in the database that I linked the tables to?

 

[Guest]

In reality, a linked table is really a connection string to the data in the
actual database table. If the table is linked, all data changes are relected
in the real table. What cannot be saved, however, are table design changes.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[John Vinson]

If a user enters new records or modifies existing records in the other
database, will these changes be automatically visible when I run the query or
report in the database that I linked the tables to?

The data is all in the same table. No matter who changes the data in
the table, it's changed - and everyone linking to it will see the
changes. A linked table is NOT a separate redundant copy of the data,
which can be changed independently; it is just a pointer to the one
shared table.


John W. Vinson[MVP]

 

[Guest]

Great! Thanks to you both for the replies.