473,326 Members | 2,438 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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
Jun 27 '08 #1
5 1294
On Fri, 9 May 2008 21:41:39 -0700 (PDT), Vincent
<an**********@verizon.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
Jun 27 '08 #2
This is an Enigma. What version of Access and or Wndows? Also, how
often do you compact your db?
Jun 27 '08 #3
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
pl*****************@msn.com
Jun 27 '08 #4
Johnnie Walker?

On May 10, 12:41*am, Vincent <animedrea...@verizon.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
Jun 27 '08 #5
"lyle fairfield" <ly************@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
Jun 27 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
by: Sean C. | last post by:
Helpful folks, Most of my previous experience with DB2 was on s390 mainframe systems and the optimizer on this platform always seemed very predictable and consistent. Since moving to a WinNT/UDB...
4
by: bhbgroup | last post by:
I have a query on one large table. I only add one condition, i.e. a date (the SQL reads like 'where date > parameterdate'. This query is rather quick if 'parameterdate' is either explicitly...
52
by: Neil | last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server...
5
by: kpp9c | last post by:
markov query I have noticed a couple markov implementations in python, but none quite seem to do what i would like. Most seem to do an analysis of some text and create a new text based on...
3
by: mnjkahn via AccessMonster.com | last post by:
I'm running Access 2003, modifying a query that has over 45 fields. When I right click on the field name in Query Design View, and then click Build, Access crashes before the Build window...
11
by: James Alan Farrell | last post by:
Hello, I recently installed new anti-virus software and was surprised the next time I brought up IDLE, that it was accessing the internet. I dislike software accessing the internet without...
10
by: Les Desser | last post by:
In article <fcebdacd-2bd8-4d07-93a8-8b69d3452f3e@s50g2000hsb.googlegroups.com>, The Frog <Mr.Frog.to.you@googlemail.comMon, 14 Apr 2008 00:45:10 writes Thank you for that. It was very...
6
by: jsacrey | last post by:
Hey everybody, got a secnario for ya that I need a bit of help with. Access 97 using linked tables from an SQL Server 2000 machine. I've created a simple query using two tables joined by one...
13
by: magickarle | last post by:
Hi, I got a pass-through query (that takes about 15 mins to process) I would like to integrate variables to it. IE: something simple: Select EmplID from empl_Lst where empl_lst.timestamp between...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.