Import records from a query.

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

I am creating a database that will be located on a user's machine to run
their stats. The database needs to access the main Access database that
contains all the stats. Is there a way in code to have the local database
access the main database and pull all the records located in a query rather
than the actual table. I cannot link the two due to the load on the network,
it needs to be a data dump.
 
I am creating a database that will be located on a user's machine to run
their stats. The database needs to access the main Access database that
contains all the stats. Is there a way in code to have the local database
access the main database and pull all the records located in a query rather
than the actual table. I cannot link the two due to the load on the network,
it needs to be a data dump.
Click to expand...

turnt he query in to an append query to a local temporary table and
then run the stats from there.
 
Back
Top