Import

[Guest]

I have a linked ODBC table that takes a really long time to run. Every time
I run a report that this table is tied to the table is going out and getting
the external data (at least I think so because these reports are taking a
ridiculously long time all the sudden). Since this data in that table is
only renewed once per day, I don't want the table to refresh itself every
time a report hits up against it. Is there a way to set that table to
refresh itself when a user opens the access database instead of every time a
report tries to access it? The users could run as many reports as they want
without having to wait for the linked table to refresh itself.
Thanks a bunch,
jordan

 

[Rick Brandt]

I have a linked ODBC table that takes a really long time to run.
Every time I run a report that this table is tied to the table is
going out and getting the external data (at least I think so because
these reports are taking a ridiculously long time all the sudden).
Since this data in that table is only renewed once per day, I don't
want the table to refresh itself every time a report hits up against
it. Is there a way to set that table to refresh itself when a user
opens the access database instead of every time a report tries to
access it? The users could run as many reports as they want without
having to wait for the linked table to refresh itself.
Thanks a bunch,
jordan

The data in a linked table only exists at the source so its not a matter of
being "renewed". It has to go get the data.

You could do a daily *import* into a local table. Then it would be faster.

 

[Guest]

Is there a way to automate that process so that the daily import to the local
table could be done without anyone needing to pay attention to it?
jordan