Make Table Query-Doubt

[neerajav]

I have a couple of tables which were created from 'Make Table Query'

I then refer these 2 tables in other sets of queries in my Access application.

My question is:

The query that I wrote to create 'Make Table Query' references linked tables.
Will the 2 new tables that created using 'Make Table Query' get refreshed everytime a new set of data has been added to the original link tables?
If so, how does this happen? Is it something related to Access internally or does it get refreshed everytime I run the report(which refers these 2 created tables?) or should I schedule a job or something?

 

[FoFa]

A linked table is a pointer (or link) to an external table. The data in the linked table is "gotten" each time you reference it, so should reflect the actual data in that linked table. How ever the data in your NEW tables from your make table queries, will remain static until you do something to it. But if you are running make table queries from linked tables, why not just run against the linked tables and do away with the make table queries?