> ## 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: May 9, 2026
- URL: https://nolongerset.com/week-in-review-2026-05-09/
- Published: 2026-05-10T03:59:00.000Z
- Updated: 2026-05-10T04:03:10.000Z
- Description: Highlights include a free SQL-to-Excel export tool, a new built-in cascading combo box feature added to the roadmap, and videos on building a Kanban board in Access.
- 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.*

- **[Access Forever](https://www.accessforever.org/)**  
  - [Feature Update from Access DevCon](https://www.accessforever.org/post/feature-update-from-access-devcon), *by Karl Donaubauer*: *Microsoft Access team demonstrated three experimental features at DevCon 2026: cascading combo/list boxes using properties, rounded control corners via CornerRadius property, and a redesigned date picker.*
- **Marcus Dieterle** ([Dieterle Programmierung](https://www.dieterle-programmierung.de/EN/index.html))  
  - [SQL to MS Excel - Export Exactly the Data You Need from Microsoft Access](https://www.dieterle-programmierung.de/EN/sql-to-ms-excel.html): *A VBA tool for Microsoft Access that provides both an interactive dialog form for building SQL SELECT statements without SQL knowledge and a direct export function for sending query results to Excel with type-safe WHERE clause generation.*
- **John Mallinson** (*[The VBA Help](https://www.thevbahelp.com/blog)*)  
  - [Beta testing of VBE\_Extras in Microsoft Visio and Microsoft Project](https://www.thevbahelp.com/post/beta-testing-of-vbe%5Fextras-in-microsoft-visio-and-microsoft-project): *VBE\_Extras developer seeks beta testers familiar with VBA in Microsoft Visio or Microsoft Project, offering free annual licenses to contributors.*
  - [VBE\_Extras catch-up #10: Next / previous code reference in this Project](https://www.thevbahelp.com/post/vbe%5Fextras-catch-up-10-next-previous-code-reference-in-this-project): *VBE\_Extras provides keyboard shortcuts (Ctrl+Shift+PgUp/PgDn) to navigate through all code references of a declaration within a VBA Project, wrapping around from last to first.*
  - [VBE\_Extras catch-up #9: Go to declaration above / below](https://www.thevbahelp.com/post/vbe%5Fextras-catch-up-9-go-to-declaration-above-below): *VBE\_Extras adds keyboard shortcuts (Ctrl+Shift+comma/period) to jump sequentially through module-level declarations within a VBA module, wrapping around at boundaries.*
  - [VBE\_Extras catch-up #8: Backup the Project](https://www.thevbahelp.com/post/vbe%5Fextras-catch-up-8-backup-the-project): *VBE\_Extras provides a command to quickly backup VBA projects from within the VBE, with configurable save locations and optional backup descriptions.*
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)  
  - [Cascading Combo and List Boxes Coming to Microsoft Access](https://www.devhut.net/cascading-combo-and-list-boxes-coming-to-microsoft-access/): *Microsoft Access will introduce cascading combo and list boxes using Link Master Field and Link Child Field properties, eliminating the need for VBA code to implement this beginner-level feature.*
  - [Microsoft Phases Out Semi-Annual Update Channel for Some Microsoft 365 Installations](https://www.devhut.net/microsoft-phases-out-semi-annual-update-channel-for-some-microsoft-365-installations/): *Microsoft is removing the Semi-Annual Enterprise Channel as an option for unmanaged devices in the Microsoft 365 admin center, pushing organizations toward faster monthly update cycles.*
  - [One Query to Understand Your SQL (Azure) Server Database Environment](https://www.devhut.net/one-query-to-understand-your-sql-azure-server-database-environment/): *A single SQL query retrieves essential database context including collation, recovery model, compatibility level, size, and connection details for both SQL Server and Azure SQL Database environments.*
  - [Power Automate – Flow – Review](https://www.devhut.net/power-automate-flow-review/): *A developer's critical assessment of Power Automate identifies major pain points including lack of inline comments, no find/replace functionality, unstable editor, missing versioning, limited error handling, and hidden properties.*
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)  
  - [Roadmap Updated - New Feature (Aug 2026)](https://isladogs.co.uk/roadmap-update-2605/index.html): *Microsoft Access roadmap confirms Link Master Field and Link Child Field properties for combo and list boxes in August 2026, plus upcoming Zoom feature rollout and removal of form/report width limits.*
  - [Switchboard Manager in modern Access versions](https://isladogs.co.uk/switchboard-manager/index.html): *Four methods to access the hidden Switchboard Manager in modern Access versions, including VBA code, Tell Me search, custom ribbon items, and Quick Access Toolbar additions.*
  - [Cascading Combo Boxes (UPDATED)](https://isladogs.co.uk/cascading-combo-boxes/index.html): *A downloadable example demonstrates building cascading combo boxes to search 28,500 UK postcodes using five linked dropdowns, with an update noting Microsoft will support this natively without code in August 2026.*
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)  
  - [Throwback Thursday: May 7, 2026](https://nolongerset.com/throwback-thursday-2026-05-07/): *A retrospective collection of articles covering VBA memory management and the Large Address Aware (LAA) flag in Microsoft Access.*
  - [twinBASIC Update: May 5, 2026](https://nolongerset.com/twinbasic-update-may-5-2026/): *Weekly twinBASIC update highlights the public release of the DevCon 2026 presentation on YouTube, clarification that subscriptions grant perpetual access to the last licensed version, and updates to fafalone's MotW utility.*

### Videos

- **Karl Donaubauer** ([YouTube channel](https://www.youtube.com/@karldonaubauer6898))

  - [Breaking Access News](https://www.youtube.com/watch?v=bccOWGWSklc) (06:24): *Feature Update from Access DevCon 2026*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/@599CD))

  - [Tables or Queries?](https://www.youtube.com/watch?v=DRN1xRs9uOY) (25:56): *Should Your Microsoft Access Forms & Reports be Based on Tables or Queries? QQ 91*
  - [Not Opening?](https://www.youtube.com/watch?v=v--5hhOSOj8) (08:13): *Microsoft Access Not Opening? Use Separate MSACCESS.EXE Instances For Each Database*
  - [Kanban Board - Part 1](https://www.youtube.com/watch?v=VIDP6yT08sA) (20:19): *Build a Kanban Board in Microsoft Access to Track Sales Pipeline, Customers, Tasks, Workflow, etc.*
  - [Kanban Board - Part 2](https://www.youtube.com/watch?v=t6DS-vYL2Uw) (20:37): *Build a Kanban Board in Microsoft Access - Part 2*
  - [File - Options](https://www.youtube.com/watch?v=P30ku55QW2c) (04:02): *Microsoft Access File Options Menu Settings Explained For Beginners*
  - [Reports Slow?](https://www.youtube.com/watch?v=nDNN3jxZXB4) (34:32): *Microsoft Access Reports Running Slow? Here's What You're Missing - QQ 90*
  - [Terminology](https://www.youtube.com/watch?v=RIV2CIaLzAI) (03:02): *Microsoft Access Database Terminology Explained For Beginners*

### GitHub Projects

[**MCP-Access**](https://github.com/unmateria/MCP-Access#changelog) — three bug-fix versions this week:

- **VBE cache correctness** ([v0.7.31](https://github.com/unmateria/MCP-Access#v0731--2026-05-03)): `_vbe_code_cache` removed entirely — it returned stale text after manual VBE edits, and the WRITE tools read through the same cache before writing, so they could overwrite the wrong baseline and corrupt code. Reported by [@TvanStiphout-Home](https://github.com/TvanStiphout-Home) in [issue #26](https://github.com/unmateria/MCP-Access/issues/26).
- **Bound-form fix** ([v0.7.33](https://github.com/unmateria/MCP-Access#v0733--2026-05-04)): `access_create_form` now actually applies `record_source` and `default_view` instead of silently dropping them — the typical subform-creation flow was producing unbound forms rendering `#Name?` on every control.
- **ODBC robustness** ([v0.7.31](https://github.com/unmateria/MCP-Access#v0731--2026-05-03)): `access_relink_table` no longer hangs the session on unreachable SQL Servers — injects `LoginTimeout=8` and runs an ADODB preflight so a bad connect string raises cleanly instead of opening a modal *SQL Server Login* dialog.
- **Off-by-one cleanup** ([v0.7.30](https://github.com/unmateria/MCP-Access#v0730--2026-05-03)): VBE write tools no longer emit spurious `Expected N lines after edit` warnings when `new_code` ends with `\r\n`. Thanks to [@CaptainStormfield](https://github.com/CaptainStormfield) in [PR #27](https://github.com/unmateria/MCP-Access/pull/27).

Tool count unchanged at 62.

[GitHub - unmateria/MCP-Access: MCP Server for editing VBA code and controls on an MS Access .ACCDB database via LLM (tested just with Claude Code)MCP Server for editing VBA code and controls on an MS Access .ACCDB database via LLM (tested just with Claude Code) - unmateria/MCP-Access![](https://github.githubassets.com/assets/pinned-octocat-093da3e6fa40.svg)GitHubunmateria![](https://repository-images.githubusercontent.com/1164343440/3af42362-2ee8-4b6a-9617-4506c33287ea)](https://github.com/unmateria/MCP-Access)

---

## New to Me

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

[AccGPT — AI-Power for Microsoft AccessAccGPT — AI toolkit for Microsoft Access. Chat with 400+ models, generate code and images, expand prompts, tune model parameters, and manage AI personas — all natively inside Access.![](https://accgpt.net/site/v1/img/logo.png)AccGPT — AI‑Power for Microsoft AccessGeoffrey L. Griffith (https://GeoffreyGriffith.com)![](https://accgpt.net/site/v1/img/web_screenshot.jpg)](https://accgpt.net/)

---

## 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/list/).

- \[[May 14, 2026](https://ukaug.co.uk/event/the-app-in-a-day-conference-may-2026/)\] **UKAUG App-in-a-Day Conference**: *Birmingham, UK*  
  - Armen Stein
  - Anders Ebro
  - Kevin Bell
  - Peter Bryant
  - Steve Girling
  - Andrew Richards
- \[[May 19, 2026](https://accessusergroups.org/calendar/sql-server-with-access-2-2-2-2026-05-19/)\] **Juan Soto**: Integrate Git into your AI environment
- \[[June 3, 2026](https://accessusergroups.org/calendar/europe-2-2026-06-03/)\] **Kevin Bell**: SQL Server Tips and Tricks for Access Developers
- \[[June 9, 2026](https://accessusergroups.org/calendar/sql-server-with-access-2-2-2/2026-06-16/)\] **Juan Soto:** Use AI to build complex features in Access
- \[[August 5, 2026](https://accessusergroups.org/calendar/europe-2026-08-05/)\] **Marcus Dieterle**: Use the Edge browser control to extend Access
- \[[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
- \[[October 7, 2026](https://accessusergroups.org/calendar/europe-2026-10-07/)\] **Peter Bryant / Andrew Richards**: GraphAuthenticator – the ‘New’ Outlook problem solved and a world of possibilities to explore

## Access Roadmap

*The *following changes were made* to the roadmap between the Week in Review last week (2026-05-02) and this week (2026-05-09).*

### *Added*

- `AUG 2026`: **Cascading combo and list boxes with LinkMasterFields/LinkChildFields:** Combo boxes and list boxes now support LinkMasterFields/LinkChildFields properties, enabling cascading dropdowns (e.g., Country filters City) without writing VBA code.

*The roadmap was last updated *May 5, 2026.**

---

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

- `MAY 2026`: **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 in Access forms, tables, and queries.
- `JUN 2026`: **Modernize Access Forms and Reports to work well on Large Format Monitors:** Remove the 22-inch size limit and modernize Access forms and reports \[to\] work well on large format monitors and provide responsive behavior for different form factors.
- `AUG 2026`: **Cascading combo and list boxes with LinkMasterFields/LinkChildFields:** Combo boxes and list boxes now support LinkMasterFields/LinkChildFields properties, enabling cascading dropdowns (e.g., Country filters City) without writing VBA code.

#### Rolling Out

None listed.

#### Launched

None listed.

## 

#### 

---

## 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

- `[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/))