Wednesday, May 28, 2014

Query too complex - Possible solution

Look for suspicious query or field names in the query itself, or in any other queries leading up to it. Avoid anything in the Microsoft Access special characters list. At the time of this writing, round parentheses ( ) are not in the list, but they should be. I had a flakey "Query Too Complex" error, failing sometimes but not others. The error went away when I deleted a pair of parentheses from the name of a query a couple of queries earlier in the chain.

Monday, February 3, 2014

Presentation Update Interrupt Block

During presentations at the local, state and national level, from small classrooms to huge convention halls, I see this often. In the middle of a presentation, over the presenter's slide pops a dialog asking if you would like to update some software now. Of course not! This is the middle of a presentation.

Some people use elaborate systems of shutting down all updaters (complicated) or Internet access (not always desirable) or creating super-clean user accounts for presentations, but this should not be necessary. Presentation software, be it Powerpoint or Keynote or Prezi or whatever, should automatically block these update requests until after the presentation is over. If operating systems do not allow such a block, then they should be rewritten so they do.

When we go to a movie, we anticipate sitting through the entire film without being asked if we want to have the projector software updated. The same should be true of any presentation.

Thursday, January 16, 2014

No, I am not that Bill Freese

Genetically modified foods? Yummy. Still, there is a lot to be said for an heirloom tomato.