ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> using pass through query
http://www.istechforum.com/YaBB.pl?num=1255460930

Message started by cathyh on 10/13/09 at 12:08:50

Title: using pass through query
Post by cathyh on 10/13/09 at 12:08:50

Is it okay to create a simple query using pass through queries instead of making a table etc?
I have three pass through queries for three different tables, and in the simple query I have used all three queries and established relationships between them in the query. It seems to work but I am not knowledgeable enough in pass through queries to know if this is going to cause problems.
I still have the issue of updating the pass through queries before running the report based on the simple query. I am not a programmer and don't even know where to begin.

Title: Re: using pass through query
Post by cathyh on 11/04/09 at 14:57:13

I know I have asked alot of questions about this but I am working my way through trying to become a better access report builder.
I have discovered that when I run the report based on the select query that is based on the pass through query, the pass through query is run also and my data in the report is up to date.

Is there a down side to this method, as opposed to make table from the pass through and select query based on the make table?
I have managed to automate the pass through and make table on opening the database, but the make table takes a long time to execute. Is this usual?