Access Query Enigma - WTF?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Vincent
    #1

    Access Query Enigma - WTF?

    I have experienced something in Access that is completely
    inexplicable and gives me shivers. I was creating a query inside the
    query wizard that I knew should return several records. I ran the
    query and it returned no results. I was staring at the design of the
    query and moved one of the tables slightly (I did NOT change the type
    of join. I simply nudged one of the tables). After doing this, I ran
    the query again and it returned several records. Believe it or not.
    I will be posting this enigma on YouTube soon for those who cannot
    imagine this could happen.

    Can anyone, Microsoft employees included, explain why this would
    occur?

    Vincent
    Tags: None
    • Tom van Stiphout
      #2
      Re: Access Query Enigma - WTF?

      On Fri, 9 May 2008 21:41:39 -0700 (PDT), Vincent
      <animedreamer@v erizon.netwrote :

      Post the link.
      But even after that I still won't be a believer.

      -Tom.

      I have experienced something in Access that is completely
      >inexplicable and gives me shivers. I was creating a query inside the
      >query wizard that I knew should return several records. I ran the
      >query and it returned no results. I was staring at the design of the
      >query and moved one of the tables slightly (I did NOT change the type
      >of join. I simply nudged one of the tables). After doing this, I ran
      >the query again and it returned several records. Believe it or not.
      >I will be posting this enigma on YouTube soon for those who cannot
      >imagine this could happen.
      >
      Can anyone, Microsoft employees included, explain why this would
      >occur?
      >
      >Vincent

        Comment

        • Dean
          #3
          Re: Access Query Enigma - WTF?

          This is an Enigma. What version of Access and or Wndows? Also, how
          often do you compact your db?

            Comment

            • Albert D. Kallal
              #4
              Re: Access Query Enigma - WTF?

              It is certainly possible you're dealing with a damaged database, or perhaps
              even damaged indexes.

              Furthermore, moving a table little bit could force the query processor to
              build a new query plan, because perhaps it thinks that you've modified the
              query again. Forcing the database engine to *re* build a new query plan
              could perhaps cause it to see some new records.

              On the other hand, perhaps there some default like now() that has a time
              based criteria that actually changed or rolled over during the time when you
              changed the table, and it simply occurred at the same time. (for example of
              this occurred at twelve midnight, you could have new date criteria now show
              up).

              On the other hand, if you're saying this is a completely repeatable
              occurrence that you can do over and over, then something else strange is
              indeed going on here.

              So, if this was just a one time occurrence, then I not much surprised at
              all, since changing things in a query in design mode causes the query
              processor to rebuild and recompile the query plan and even the statistics
              that JET will use for the query.

              --
              Albert D. Kallal (Access MVP)
              Edmonton, Alberta Canada
              pleaseNOOSpamKa llal@msn.com


                Comment

                • lyle fairfield
                  #5
                  Re: Access Query Enigma - WTF?

                  Johnnie Walker?

                  On May 10, 12:41 am, Vincent <animedrea...@v erizon.netwrote :
                       I have experienced something in Access that is completely
                  inexplicable and gives me shivers.  I was creating a query inside the
                  query wizard that I knew should return several records.  I ran the
                  query and it returned no results.  I was staring at the design of the
                  query and moved one of the tables slightly (I did NOT change the type
                  of join.  I simply nudged one of the tables).  After doing this, I ran
                  the query again and it returned several records.  Believe it or not.
                  I will be posting this enigma on YouTube soon for those who cannot
                  imagine this could happen.
                  >
                       Can anyone, Microsoft employees included, explain why this would
                  occur?
                  >
                  Vincent

                    Comment

                    • Larry Linson
                      #6
                      Re: Access Query Enigma - WTF?

                      "lyle fairfield" <lyle.fairfield @gmail.comwrote
                      Johnnie Walker?
                      How dare Ol' Johnny be messing around with our Queries? Does he work for one
                      of those other database companies?

                      Larry


                        Comment

                        Previous template Next
                        Working...