accessing data for a report from a remote location

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for ways to run a report using data located in a database
external to the one i'm running the report in. I do NOT want to link tables
due to security concerns related to some of the data stored in the tables.

I could import specific data into a "temp" table on the current db from the
remote one, but this poses size problems over time as the users are unlikely
to compact their "front-end" copies of the db.

Any idea's?

Thank you.
 
I would use your temp table approach and do a couple of other things.
1. delete everything out of the temp table before importing into it and
after completeing the report.

This is a really good approach that will give your best response time. I
see too many times where apps are designed where a temp table is in the BE
and they are building it from another table in the BE. Talk about "How can I
double Network Traffic, and slow my app to a crawl!"

2. Set your FE db to compact on close. That will solve that problem.
Whether or not you are using temp tables, this is always a good idea. It
keeps things cleaner and less likely to go south on you.
 
Back
Top