MS Access

Posted on 2012-09-21
Medium Priority
Last Modified: 2012-09-21
Generally speaking, if I build a query in MS Access (original) that uses a table that was generated by a separate Make-Table query and then I run the original query, does the underlying Make-Table query get run first, thereby updating the corresponding table that gets used in the original query?

Question by:maroulator
LVL 75
ID: 38423699
Queries run in what ever order You (or your code) executes them.

LVL 66

Accepted Solution

Jim Horn earned 1500 total points
ID: 38423730
translation:  No.

If you run a query against a table that was created by (insert any process here), it just runs against the table.   The fact that the table was created by a make-table query is not relevant.

Now if you ran query1 against query2, then yes query2 would run first.

>Make-Table query get run first, thereby updating the corresponding table that gets used in the original query?
Make-table queries create tables, not update them.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

807 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