News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Patch Lady – Access bug will be fixed sooner versus later

    Posted on Susan Bradley Comment on the AskWoody Lounge

    Home Forums AskWoody blog Patch Lady – Access bug will be fixed sooner versus later

    This topic contains 5 replies, has 5 voices, and was last updated by  gborn 3 weeks, 4 days ago.

    • Author
      Posts
    • #2007576 Reply

      Susan Bradley
      AskWoody MVP
    • #2007610 Reply

      anonymous

      Perhaps I am a little overly critical but, it seems to me that any prior release QA testing regimen would catch an error like this hands down. It really is emblematic of the anecdotal deterioration in MS patch quality over the last several years.

    • #2007680 Reply

      Susan Bradley
      AskWoody MVP

      It’s easy to say why didn’t they…. this is a bug that you only find if you use Access.  If you install it, Access still opens, everything LOOKs okay.  You have to have a functional database to get the bug.  IMHO patch quality has not changed in 19 years.  Seriously.  There will be bugs that you always will only see if you actually USE the program.  That takes a real database and real users.  Even when they had old fashioned testers I’d doubt they would have caught this bug either.

      Look at me, I advised to install the IE zero day patch and it wasn’t until Monday morning when we actually used a line of business app that I realized how impactful it was to certain types of printing.

      Susan Bradley Patch Lady

      1 user thanked author for this post.
      • #2007734 Reply

        warrenrumak
        AskWoody Plus

        Reminds me of a time when we installed a set of fixes from a vendor to help with performance problems on a SQL database.

        We installed the fix it helped a lot for several months…. until the early hours of Sept 5, 2007 when everything came to a screeching halt.

        See, the database had a thing in it that would generate a date/time string like “Wednesday September 5, 2007 @ 12:30:00 AM”.  But it was trying to stuff that 41 character string into a field that could store 40 characters maximum.  (Reducing the size of fields was one of their performance optimization)

        This bug would therefore only happen on every Wednesday in September, because “Wednesday” has the most letters of any day of the week, and “September” has the most letters of any month.

        At the time I remember saying that if this crash had happened a week later, we probably would’ve blamed Patch Tuesday. (Though if I remember right, there were no Windows security patches that month….)

    • #2007781 Reply

      mn–
      AskWoody Lounger

      But it was trying to stuff that 41 character string into a field that could store 40 characters maximum.  (Reducing the size of fields was one of their performance optimization)

      This bug would therefore only happen on every Wednesday in September, because “Wednesday” has the most letters of any day of the week, and “September” has the most letters of any month.

      … and that’s English only, now imagine supporting multiple languages.

      And this is why a proper QA procedure for a database is tedious.

      Yes, a previous employer did produce a “layered software product” that depended on a database engine, among other things. The QA procedure did include fast-forwarding the entire test lab into various points in time and running it through those, such as timezone changes, February (29th) and December (day 366) of leap years and…

      And it was a bit of a bother because that was one way only, databases really don’t like it when time runs backwards.

      (Also ISTR that procedure caught at least one bug related to the product’s database server component being on one timezone and client on one of the timezones that differed in minutes too, during a DST change.)

      1 user thanked author for this post.
    • #2007870 Reply

      gborn
      AskWoody_MVP

      The click-to-run version of Access 2016 seems also to have a fix. Search for updates – Build 12130.20390 shall fix the query bug.

      Fix for Error 3340 in Access 2016 (Update KB4484198)

      Microsoft Windows Insider MVP, Microsoft Answers Community Moderator, Blogger, Book author

      https://www.borncity.com/win/

      1 user thanked author for this post.

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Patch Lady – Access bug will be fixed sooner versus later

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.