asked on Pass through Query
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"?
Microsoft ApplicationsMicrosoft Access
Last Comment
Armen Stein - Microsoft Access MVP since 2006
ASKER
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.
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
If you want a snapshot of the dataset returned by the pass-through query then you should use a temp table.
OM Gang
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
In most situations I'd think we'd want the pass-through query to execute every time to capture any recent changes.
OM Gang