> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Week in Review: March 7, 2026
- URL: https://nolongerset.com/week-in-review-2026-03-07/
- Published: 2026-03-08T04:59:00.000Z
- Updated: 2026-05-08T12:48:36.000Z
- Description: Highlights include Monaco query editor fixes, group-wise ranking with class modules, message boxes with timeouts, and visual badges over the Access taskbar icon.
- Author: Mike Wolfe
- Tags: Week in Review, #Import 2026-05-20 02:59

## Just Published

This section includes videos, articles, and (occasionally) open-source project updates from the past 7 days.

### Articles

\* *Article descriptions generated by Claude-Sonnet-4.5.*

- **[Official Access Blog](https://techcommunity.microsoft.com/t5/access-blog/bg-p/AccessBlog)**  
  - [Access fixes released in version 2602 (Build 19725.20126)](https://techcommunity.microsoft.com/blog/accessblog/access-fixes-released-in-version-2602-build-19725-20126/4498826), *by LindaLu Cannon*: *Microsoft releases fixes for the Monaco query editor, including disabled autoformatting for passthrough queries, corrected font sizing, and improved datasheet selection behavior.*
- **a.p.r. pillai** ([Learn MS-Access Tips and Tricks](https://www.msaccesstips.com/))  
  - [Group-Wise Ranking in Microsoft Access Using a Class Module](https://www.msaccesstips.com/2026/03/group-wise-ranking-using-class-module.html): *A reusable, object-oriented approach to implementing group-wise ranking logic (dense, competition, and sequential styles) using VBA class modules in Access.*
- **Marcus Dieterle** ([LinkedIn Articles](https://www.linkedin.com/in/marcus-dieterle-557572222/recent-activity/articles/))  
  - [🚨 "It works on my machine – but not on the client's."](https://www.linkedin.com/pulse/works-my-machine-clients-marcus-dieterle-i9dtf/): *A lightweight VBA system check tool that collects comprehensive environment data (OS, Office version, bitness, references) to troubleshoot deployment issues across client workstations.*
- **John Mallinson** ([The VBA Help](https://www.thevbahelp.com/blog))  
  - [Getting the alternate data streams (ADS) for a file or folder](https://www.thevbahelp.com/post/getting-the-alternate-data-streams-ads-for-a-file-or-folder): *An introduction to alternate data streams in NTFS file systems, with Windows API code to enumerate streams attached to files and folders.*
  - [Reading, writing and deleting alternate data streams (ADS)](https://www.thevbahelp.com/post/reading-writing-and-deleting-alternate-data-streams-ads): *Windows API Functions (CreateFile, ReadFile, WriteFile, DeleteFile) for reading stream data, writing custom streams, and removing streams from files and folders.*
  - [The ":Zone.Identifier:$DATA" alternate data stream (ADS)](https://www.thevbahelp.com/post/the-zone-identifier-data-alternate-data-stream-ads): *Understanding the "Mark of the Web" stream that blocks downloaded files, with VBA Functions to detect and programmatically unblock files by removing the Zone.Identifier stream.*
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)  
  - [Add a Timeout to Message Boxes](https://isladogs.co.uk/msg-box-timeout/index.html): *Three approaches to adding auto-close timeouts to Access message boxes: using MessageBoxTimeout API, custom modal forms with timer events, and third-party enhanced message box solutions with countdown features.*
  - [Dates in Excel and Access](https://isladogs.co.uk/dates-excel-access/index.html): *Explains the historical differences between Excel and Access date systems, including Excel's inherited Lotus 1-2-3 leap year bug for 1900, and why dates are consistent between both applications from March 1, 1900 onwards.*
  - [AEU51: Using Grid Lanes in Access](https://isladogs.co.uk/aeu-51/index.html): *A presentation preview on creating a 2D grid with draggable objects using GDI commands and class modules, demonstrated through a scheduling application integrated with Google Maps.*
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)  
  - [Throwback Thursday: March 5, 2026](https://nolongerset.com/throwback-thursday-2026-03-05/): *A curated collection of articles revisiting best practices for autonumbers, primary keys, and deciding when to store numbers as text versus numeric fields.*

### Videos‌

- **Richard Rost** ([YouTube channel](https://www.youtube.com/@599CD))  
  - [Refuses to Calculate](https://www.youtube.com/watch?v=Eg-yFucib9s) (37:58): *Why Microsoft Access Refuses to Calculate a Form Footer Total That Should Work - QQ #82*
  - [MkDir](https://www.youtube.com/watch?v=J08sLPsI00E) (16:51): *How to Create File Folders in Microsoft Access VBA Using the MkDir Statement*
  - [Dir Function](https://www.youtube.com/watch?v=eCFe-QDPpfI) (11:14): *How To Test If A File Exists In Microsoft Access VBA Using The Dir Function*
  - [Access Developer 53](https://www.youtube.com/watch?v=6dOyA6DaBvg) (03:11): *Recycle Bin, Word Docs, Import Automation & Recursive MkDir*
  - [SQL Server for Access Users - Beginner 1 Lesson 12](https://www.youtube.com/watch?v=HnrFrhgzIno) (29:30): *SQL Server Vs Microsoft Access SQL Differences*

---

## New to Me

This section includes content I discovered this week that has been around for a while.

[Adding badges over the Access taskbar icon.This code allows you to place a small status icon (e.g., a red circle, a green check, or a number icon) over your Access taskbar button. It also allows to create and display dynamic images (using GDI+) over the taskbar button. Some examples: If you are opening multiple front ends on the same…![](https://www.access-programmers.co.uk/favicon.ico)Access World ForumsJason Lee Hayes![](https://www.access-programmers.co.uk/forums/attachments/1772533651250-png.123380/)](https://www.access-programmers.co.uk/forums/threads/adding-badges-over-the-access-taskbar-icon.335249/)

---

## Upcoming Access User Group Events

NOTE: Only English-language user group meetings with scheduled guest speakers or topics are listed. For a complete list of upcoming events, visit the [Access User Group event calendar](https://accessusergroups.org/calendar/). Not all links below include the start time and time zone. For that information, check out this handy reference guide from Access MVP Maria Barnes over at AccessForever.org: [Access User Groups 2025](https://www.accessforever.org/post/access-user-groups-2025). 

- \[[March 10, 2026](https://accessusergroups.org/calendar/sql-server-with-access-2-2-2-2026-03-10/)\] **Roy Kim**: Chatbot Against Your Documents with AKS RAG Engine ***(JUST ADDED)***
- \[[March 27, 2026](https://www.jstreettech.com/access-day/)\] **Access Day** (*in person in Redmond, WA*):
  - **Armen Stein**: Start and Grow Your Consulting Business
  - **Mike Wolfe**: Long-Term Care for Access: Taking Over an Existing Application
  - **Rochelle Long**: Managing IP rules for Azure SQL Server from within your Access Application
  - **Andrew Richards & Peter Bryant**: GraphAuthenticator - the “New Outlook” problem solved and a world of possibilities to explore
  - **Juan Soto**: Using AI as your Access Development Assistant
  - **Access Team** (*Linda Cannon, Shane Groff, Courtney Owen, Sachin Arunkumar*): Access News and Demos of New Features
- \[[March 31, 2026](https://accessusergroups.org/calendar/lunchtime-2-2026-03-31/)\] **Maria Barnes**: Interfacing with the Outlook calendar
- \[[April 1, 2026](https://accessusergroups.org/calendar/europe-2-2026-04-01/)\] **Peter Cole**: Using vbWatchdog with Access
- \[[April 16-17, 2026](https://www.donkarl.com/devcon/)\] **Access DevCon Vienna** (*virtual*): speakers TBA
- \[[May 6, 2026](https://accessusergroups.org/calendar/europe-2-2026-05-06/)\] **Tim Finch**: Grid Lanes
- \[[June 3, 2026](https://accessusergroups.org/calendar/europe-2-2026-06-03/)\] **Kevin Bell**: SQL Server Tips and Tricks for Access Developers
- \[[September 2, 2026](https://accessusergroups.org/calendar/access-europe-john-mallinson-api-magic-with-office-apps-2026-09-02/)\] **John Mallinson**: Working with the Windows API

---

## Access Roadmap

*There were *no changes made* to the roadmap between the Week in Review last week (2026-02-28) and this week (2026-03-07).*

*The roadmap was last updated *October 15, 2025.**

---

Listed below is a snapshot of the [official Access Roadmap](https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=%5B%22Access%22%5D).

"In Development", "Rolling Out", and "Launched" are Microsoft terms that I pulled straight from the public roadmap. Dates listed are "rollout start" dates.

#### In Development

- `OCT 2025`: **Add zoom slider magnification to Microsoft Access:** Access will add magnification slider (10% to 500%) in lower right of the application, similar to the feature in Word, PowerPoint, and Excel. It will also be keyboard accessible and available on the ribbon.
- `DEC 2025`: **Modernize Access Forms and Reports to work well on Large Format Monitors:** Remove the 22-inch size limit and modernize Access forms and reports work well on large format monitors and provide responsive behavior for different form factors.

#### Rolling Out

None listed.

#### Launched

None listed.

## Development Priorities

"Development Priorities" do not appear on the Access Roadmap. Instead, they get updated from time to time in official Access blog posts or Access engineering team presentations. I'll include a link to the source of the current development priorities as they get updated.

The items listed below reflect Microsoft's order of priority and were published in the following Access Forever article, [Microsoft's Plans for Access Oct '25 – March '26](https://www.accessforever.org/post/microsoft-s-plans-for-access-oct-25-march-26#viewer-f41l9592).

1. Continued **focus on monthly issue** fixes, security, customer-reported bugs, etc. to improve product quality, security, reliability, and relevance. Most of our engineering hours are spent here.
2. Large monitor support: Remove 22” limitation to support using Access on modern hardware.
3. Large monitor support: Enable zoom slider magnification for forms.
4. Large monitor support: Modernize forms to work well on large monitors.
5. Time allowing, we’ll continue to work on remaining large monitor support features (support zoom in reports and design layout, automatic zooming, support multiple monitor scenarios).
6. If we still have time left over in the semester, we will begin work on **Git integration for source code management** in Access. (Spec is in progress. We will likely roll this out in phases also beginning the second half of 2026.)

Special thanks to Karl Donaubauer for posting the updated priorities at [AccessForever.org](https://www.accessforever.org/post/microsoft-s-plans-for-access-oct-25-march-26).

#### 

---

## Upcoming End-of-Life Dates

Here are the key end-of-life dates Access developers should track:

### 2024

- ~~`[JUL 09]`~~ *[SQL Server 2014](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2014)*

### 2025

- ~~`[OCT 14]`~~ *[Access 2016](https://learn.microsoft.com/en-us/lifecycle/products/access-2016) | [Access 2019](https://learn.microsoft.com/en-us/lifecycle/products/access-2019) | [Office 2016](https://learn.microsoft.com/en-us/lifecycle/products/microsoft-office-2016) | [Office 2019](https://learn.microsoft.com/en-us/lifecycle/products/microsoft-office-2019)*
- ~~`[OCT 14]`~~ *[Windows 10](https://www.microsoft.com/en-us/windows/end-of-support)*
- ~~`[OCT 28]`~~ *[Salesforce ODBC Driver](https://techcommunity.microsoft.com/blog/accessblog/access-announces-removal-of-salesforce-odbc-driver-in-october-2025/4408815)*
- ~~`[NOV 11]`~~ *[Windows 11 version 23H2](https://en.wikipedia.org/wiki/Template:Windows%5F11%5Fversions)*

### 2026

- `[APR 01]` *[Auto-migration of Classic Outlook begins for Enterprise users](https://nolongerset.com/new-outlook-tale-of-two-cities/)* **[\[POSTPONED TO MARCH 2027\]](https://mc.merill.net/message/MC949965)**
- `[JUL 14]` [SQL Server 2016](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2016)
- `[OCT 13]` [Access 2021](https://learn.microsoft.com/en-us/lifecycle/products/access-2021) | [Office 2021](https://learn.microsoft.com/en-us/lifecycle/products/office-2021)
- `[OCT 13]` [Windows 11 version 24H2](https://en.wikipedia.org/wiki/Template:Windows%5F11%5Fversions)

### 2027

- `[JAN 12]` [Windows Server 2016](https://learn.microsoft.com/en-us/lifecycle/products/windows-server-2016)
- `[MAR 01]` [Auto-migration of Classic Outlook begins for Enterprise users](https://nolongerset.com/new-outlook-tale-of-two-cities/) *(originally scheduled for April 2026, but [postponed to March 2027](https://mc.merill.net/message/MC949965))*
- `[OCT 12]` [SQL Server 2017](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2017)

### 2029

- `[JAN 09]` [Windows Server 2019](https://learn.microsoft.com/en-us/lifecycle/products/windows-server-2019)
- `[OCT 09]` [Access 2024](https://learn.microsoft.com/en-us/lifecycle/products/access-2024) | [Outlook 2024](https://learn.microsoft.com/en-us/lifecycle/products/outlook-2024)
- `[OCT 09` *(or later)*`]` [**Classic Outlook**](https://techcommunity.microsoft.com/blog/outlook/new-outlook-for-windows-a-guide-to-product-availability/4078895)  
  - *See "Edit 8/12/2024" at top of [this article](https://techcommunity.microsoft.com/blog/outlook/new-outlook-for-windows-a-guide-to-product-availability/4078895) for official clarification that "both perpetual and subscription \[i.e., MS 365\] versions of Outlook will be supported until 2029"*
  - *Support for Classic Outlook is guaranteed *at least through 9 Oct 2029*; it may be extended beyond this date*

### 2030

- `[JAN 08]` [SQL Server 2019](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2019)

### 2031

- `[OCT 14]` [Windows Server 2022](https://learn.microsoft.com/en-us/lifecycle/products/windows-server-2022)

### 2033

- `[JAN 11]` [SQL Server 2022](https://learn.microsoft.com/en-us/lifecycle/products/sql-server-2022)

### 2034

- `[OCT 10]` [Windows Server 2025](https://learn.microsoft.com/en-us/lifecycle/products/windows-server-2025)

### Ongoing

- [Microsoft 365](https://learn.microsoft.com/en-us/lifecycle/products/microsoft-365) (with subscription)

### Date TBD

- Complete removal of VBScript from Windows OS ([Microsoft Announces the Death of VBScript](https://nolongerset.com/vbscript-deprecation/))