pass-through query questions

[LMRollins]

I'm trying to create a report. At first I was going to link my sql tables but then I read about pass-through queries. I need the info to be up-to-date everytime the report is run. All I want my people to be able to do is run this report and then print it. If I use the pass-through query will it cause any changes to the sql database?

I'm going to use two tables from my SQL using pass-thru and then make a combination table of the two for my report. When the report is run will the information be current to my sql database?

 

[cmmrfrds]

It will be current in either case. The linked table just provides a way to get to the sql server table it is not a separate copy of the data.

I would still go with the pass through query since it is more efficient. A "Select" sql statement retrieves results it does not do any updates to the database there are separate sql statements that modify the database.