Append Table from Network on Open

[mkallover]

Here is my problem:

I'm creating a database that uses three tables from my company's mainframe. Running queries on these tables can be very slow because of the size and because of network speed.

What I'd like to know is if there would be a way to keep a local copy of that table that can be updated either whenever a user opens the database or by clicking an "Update" button within the database.

 

[PHV]

Running queries on these tables can be very slow
Even PassThru queries ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mkallover]

No, I run mostly counts and pivots. The tables are transactional data and I'm typically researching transaction counts for customers and acceptance rates.

 

[dhookom]

I think what PH is suggesting is that you use pass-through queries so that your filtering, sorting, and joining can occur on the "company's mainframe".

Once your records get to Access, you can do your analysis or whatever.

Duane
Hook'D on Access
MS Access MVP