[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Pass through Query

Posted on 2010-11-16
4
Medium Priority
?
456 Views
Last Modified: 2012-06-27
If I run a query (let's call it "Accounts") against a pass-through query and I have already executed the pass-through previously, does the pass through get executed again every time  I run "Accounts"?
0
Comment
Question by:chaffee007
  • 2
4 Comments
 
LVL 28

Expert Comment

by:omgang
ID: 34150286
I believe so but I haven't actually tested it.  I would not think the return recordset would be cached.
In most situations I'd think we'd want the pass-through query to execute every time to capture any recent changes.

OM Gang
0
 

Author Comment

by:chaffee007
ID: 34150312
Yes I need to Just snapshot the data.  Otherwise I need to create another Make Table Query to create my shadow table.  I would give you the points if you can confirm it.
0
 
LVL 28

Expert Comment

by:omgang
ID: 34150579
This is something you can test easily yourself.  Run a pass-through query on a table.  Edit a record in the table.  Run the pass-through query again.

If you want a snapshot of the dataset returned by the pass-through query then you should use a temp table.

OM Gang
0
 
LVL 9

Accepted Solution

by:
Armen Stein - Microsoft Access MVP since 2006 earned 2000 total points
ID: 34157986
Yes, a passthrough query retrieves fresh data from the server every time it runs.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question