IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Theory and Practice of Programming Forum / Ok, now I REALLY cornfuzed
Post #319,260
by jbrabeck
12/29/09 9:01:37 AM
Reply
New Ok, now I REALLY cornfuzed
Ran the compact/repair database utility. No change.

So I deleted the query and recreated it.

Works like it should. SQL select statement is EXACTLY like the original.

What a PIA.

Thanks Peter and Wade for suggestions.

If anyone else knows what might be causing this, please let me know. I hate having to recreate the query on a regular basis.
Post #319,295
by Mycroft_Holmes_Iv
12/29/09 11:04:08 PM
Reply
New Possible theory...
the SQL gets boiled down to a binary-verion-meta data thingy. I'm guessing Access then stores this query. If the query is semi-used often and it doesn't change, it'll pull the binary version rather than reboil the text down.

Now...the question is why the boiled down version was somehow modified. No idea there, but if Access thought the query was still the same, it wouldn't recalculate it.

That would explain why 'recreating' the sql fixed the problem.
     Another MS Access Question - (jbrabeck) - (16) - Dec. 28, 2009, 08:16:56 PM EST
         Why does the column order matter? - (static) - (5) - Dec. 28, 2009, 08:44:52 PM EST
             Output is used for other documents - (jbrabeck) - (4) - Dec. 29, 2009, 05:26:29 AM EST
                 Ouch. - (static) - (3) - Dec. 29, 2009, 07:38:09 AM EST
                     Wish I could ditch Access - (jbrabeck) - (2) - Dec. 29, 2009, 09:06:09 AM EST
                         Harder? - (crazy) - (1) - Dec. 30, 2009, 09:54:24 AM EST
                             Well... - (folkert) - Dec. 30, 2009, 02:52:12 PM EST
         Re: Another MS Access Question - (pwhysall) - (6) - Dec. 29, 2009, 03:30:39 AM EST
             I have dragged to columns around - (jbrabeck) - (5) - Dec. 29, 2009, 05:20:11 AM EST
                 How peculiar. - (pwhysall) - (4) - Dec. 29, 2009, 05:41:46 AM EST
                     I am the "DBA" - (jbrabeck) - (3) - Dec. 29, 2009, 05:46:47 AM EST
                         I'm clutching at straws, TBH - (pwhysall) - (2) - Dec. 29, 2009, 05:49:25 AM EST
                             I understand... - (jbrabeck) - (1) - Dec. 29, 2009, 05:58:30 AM EST
                                 Time to put a report in the way, I think - (pwhysall) - Dec. 29, 2009, 08:36:24 AM EST
         Ok, now I REALLY cornfuzed - (jbrabeck) - (1) - Dec. 29, 2009, 09:01:37 AM EST
             Possible theory... - (Mycroft_Holmes_Iv) - Dec. 29, 2009, 11:04:08 PM EST
         Are the tables linked from elsewhere? - (scoenye) - Dec. 30, 2009, 07:28:43 PM EST

Almost, but not quite, entirely unlike tea.
43 ms