Solved

Pass through Query

Posted on 2010-11-16
4
415 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 500 total points
ID: 34157986
Yes, a passthrough query retrieves fresh data from the server every time it runs.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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 …

912 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now