Posts Tagged


Microsoft starts releasing fixes for Access bugs introduced in Office security patches this month

Although we’ve been promised no “C” or “D” week second cumulative updates for the rest of the year — at least for Windows — Microsoft has acknowledged a bug it created in last week’s Patch Tuesday Office patches, and now promises that it’ll update the bad fixes on most machines this week or next. Those are “C” week and “D” week, respectively.

The cause du jour: a bug in all of this month’s Office security patches that throws an error in Access saying, “Query xxxx is corrupt,” when in fact the query in question is just fine. Microsoft describes the erroneous error message on its Office Support site:

query is corrupt Woody Leonhard/IDG

When attempting to run an Update query, it may not run and displays the error: “Query ‘query name’ is corrupt”. 

This will occur for an Update query that:

  • Updates a single table (i.e. it updates a table, rather than the output of a Select query, or join
  • Specifies a WHERE clause (i.e. has entries in the Criteria row in the query designer)

This issue impacts all supported builds of Access.

The issue was introduced on November 12, 2019

It’s the same bug I discussed in Woody on Windows on Nov. 13. It just took Microsoft a week to acknowledge the error.

There’s a new cumulative update for Office 2016 (the installed version, not the Click-to-Run) released yesterday, KB 4484198, that claims to fix the bug. According to Microsoft, we should expect to see similar fixes for Access 2010, 2013, and Office 365 (the Click-to-Run version 1911) this Friday, Nov. 22. The fix for Office 365 Semi-Annual channel (version 1901) is due next Monday, and Volume Licensees won’t get the bug erased until Dec. 10. Which is why you pay for a Volume License, right?

Günter Born also reports that Access 2016 Click-to-Run has already been fixed, with build 12130.20390, according to a German-language post. 

Stuck with Access? Join us on AskWoody.

Copyright © 2019 IDG Communications, Inc.

Source link

The 1970s Oil Crisis In The United States Introduced What Automotive-Related Change?

Example of a right turn sign reading "After stop, right turn permitted on red"

Answer: Right Turn On Red

Although U.S. drivers take turning right on red lights for granted these days (outside of the few areas where it remains restricted), historically, right-turn-on-red wasn’t widely adopted outside of sparsely populated areas in western states.

All that changed when the gasoline shortages of the 1970s left the U.S. government reaching for any solution that would increase fuel efficiency and cut down on consumption. Federal Highway Administration sponsored studies revealed that allowing right-turn-on-red when traffic was clear reduced the waiting time by 9 to 30 percent based on traffic conditions and, as such, actually made a pretty significant dent in the amount of time drivers spent idling.

By early 1980, all fifty U.S. states had adopted right-turn-on-red regulations and what was a driving curiosity forty years ago is commonplace today.

Source link

Which Color Name Was Introduced To The English Language Via Plant?

Geek Trivia

Which Color Name Was Introduced To The English Language Via Plant?

The Bluetooth Communication Protocol Is Named After?

Oranges and orange juice, sitting on a white table

Answer: Orange

Once upon a time in an England far removed from the present, Englishmen were for want of a specific word to describe what we now call “orange”. What we would now casually refer to as orange in color they called, depending on its shade, a variety of different compound Old English words including ġeolurēad (yellow-red) to describe reddish orange, or ġeolucrog (yellow-saffron) to describe yellowish-orange.

It was only when they were introduced to the fruit by the French, which was called “orange” in the Old French of the day, did the word enter into the English language to give that particular shade of yellowish-red a distinct name. The first recorded instance of “orange” as a color designation in the English language was in 1512.

Source link