MS Access

Posted on 2012-09-21
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

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    Queries run in what ever order You (or your code) executes them.

    LVL 65

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    779 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

    14 Experts available now in Live!

    Get 1:1 Help Now