Week in Review: April 25, 2026
Highlights include interfacing with the Outlook Calendar from VBA, an ODBC bug in the legacy SQL Server driver, and support for returning Access version info via SysCmd.
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
- Access fixes released in Version 2604 (Build 16.0.19929.20090), by LindaLu Cannon: A summary of the 14 bug fixes included in the latest Access release, addressing issues ranging from subform display errors and Long Text field corruption to Unicode handling, font rendering, and missing aggregate functions in query design.
- Access Forever (Access Forever)
- New SysCmd actions: Version Info by Colin Riddington: Use new officially supported SysCmd actions (715-725) in Access 365 version 2604 and later to retrieve detailed version information including build numbers, update channel, and bitness.
- ODBC INSERT on linked SQL Server tables in Access Fails by George Hepworth: Resolve Access 2604 build 19929.20090 ODBC errors when inserting into SQL Server nvarchar(max) fields by upgrading to ODBC Driver 18, modifying registry settings, or rolling back to version 2603.
- Juan Soto (Access Experts)
- Tuesday April 21st: Learn AI with Access!: Juan Soto announces a three-month series of AccessUserGroups.org sessions exploring how to use AI tools — alongside Visual Studio Code and Git — to analyze, modify, and build new features in Microsoft Access databases.
- John Mallinson (The VBA Help)
- VBE_Extras catch-up #3: Project statistics: Generate comprehensive statistics for your VBA projects including procedure counts, code lines, comment lines, blank lines, and Option Explicit verification with exportable CSV results.
- VBE_Extras catch-up #2: Listing all declarations: List and filter all declarations (variables, constants, procedures, properties, types, enums, API functions) in a VBA procedure, module, or entire project with search and reference-finding capabilities.
- VBE_Extras catch-up #1: The Module-picker (and the Project Picker): Navigate between VBA modules and projects using keyboard-centric pickers (Ctrl+Tab and Ctrl+1) that display modules in last-accessed order for efficient code navigation.
- Daniel Pineault (DEVelopers HUT)
- A Simple Query to Reveal Key SQL Server Details: Learn how to use the SERVERPROPERTY function to quickly retrieve essential SQL Server metadata including version, edition, clustering status, and security configuration in a single query.
- Office Build 2604 Breaks Microsoft Access ODBC: Discover the ODBC connection issues affecting Access users on Office Build 2604 and explore three workarounds including driver updates and registry modifications.
- Colin Riddington (Isladogs on Access)
- Access / Office Bug Summary - Apr 2026: Review the April 2026 Access bugs including Edge browser control crashes, keyboard input issues, ODBC caching regressions, and continuous subform display problems with their current status.
- Add Style to Windows, Forms and Message Boxes: Access the slide deck and resources from the Access DevCon 2026 presentation covering popup form personalization, theme-aware forms, and new Fluent UI message boxes with timeout.
- Mike Wolfe (NoLongerSet)
- UKAUG: App-in-a-Day Conference: Register for the May 19, 2026 UKAUG conference in Birmingham where six international presenters will collaboratively build a complete Access application in a single day.
- Throwback Thursday: April 23, 2026: Revisit articles about the pitfalls of leaving old code and unused database fields in your Access applications and the technical debt they create.
- twinBASIC Update: April 21, 2026: Access the slide deck and source code from the DevCon Vienna 2026 twinBASIC presentation, plus discover a WinRT alternative implementation for folder watching functionality.
Videos
- Access User Group Recordings (YouTube channel)
- Setting up Access MCP Server in Visual Studio Code (10:20): with Juan Soto
- Setting up your Environment using Microsoft Access with AI (01:27:35): with Juan Soto
- Interfacing with the Outlook Calendar using VBA from Access (01:02:29): with Maria Barnes
- Richard Rost (YouTube channel)
- Dark Mode (20:50): How To Create Dark Mode In Microsoft Access Forms Switch Light And Dark With VBA
- Access Install Error (QQ88) (01:00:36): x64 Fix plus answers to YouTube comments and more
- Access Install Error (10:45): Microsoft Access Database Engine x64.exe Install Error. AccessDatabaseEngine_x64.exe Fix
New to Me
This section includes content I discovered this week that has been around for a while.
An early attempt to convert an Access application to Blazor using AI (via YouTube):
According to the presenters, this technique gets you 85-95% of the way to a working solution in a brand new language.
And then all you have to do as a developer is perform those final few tweaks to provide the remaining 50% of functionality.
This looks like the sort of service that will sell really well to IT executives (CTOs, CIOs, CISOs, etc.), but actual end users will hate it.
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.
- [April 28, 2026] Maria Barnes: Zooming in Access (JUST ADDED)
- [May 6, 2026] Tim Finch: Grid Lanes
- [May 7, 2026] John Colozzi: Access Isn’t Dead. It Finally Got a “Co-Pilot”. (No. Not that one.)
- [May 14, 2026] UKAUG App-in-a-Day Conference: Birmingham, UK (JUST ADDED)
- Armen Stein
- Anders Ebro
- Kevin Bell
- Peter Bryant
- Steve Girling
- Andrew Richards
- [May 19, 2026] Juan Soto: Integrate Git into your AI environment
- [June 3, 2026] Kevin Bell: SQL Server Tips and Tricks for Access Developers
- [June 9, 2026] Juan Soto: Use AI to build complex features in Access
- [August 5, 2026] Marcus Dieterle: Use the Edge browser control to extend Access
- [September 2, 2026] John Mallinson: Working with the Windows API
Access Roadmap
The following changes were made to the roadmap between the Week in Review last week (2026-04-18) and this week (2026-04-25).
- Rollout date changed from
APR 2026toMAY 2026for the Zoom Slider feature. - "...in Access forms, tables, and queries" added to the end of the Zoom Slider feature description to clarify which objects will receive initial zoom support.
The roadmap was last updated April 20, 2026.
Listed below is a snapshot of the official Access Roadmap.
"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.
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.
- 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.
- Large monitor support: Remove 22” limitation to support using Access on modern hardware.
- Large monitor support: Enable zoom slider magnification for forms.
- Large monitor support: Modernize forms to work well on large monitors.
- 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).
- 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.
Upcoming End-of-Life Dates
Here are the key end-of-life dates Access developers should track:
2024
SQL Server 2014[JUL 09]
2025
Access 2016 | Access 2019 | Office 2016 | Office 2019[OCT 14]Windows 10[OCT 14]Salesforce ODBC Driver[OCT 28]Windows 11 version 23H2[NOV 11]
2026
[JUL 14]SQL Server 2016[OCT 13]Access 2021 | Office 2021[OCT 13]Windows 11 version 24H2
2027
[JAN 12]Windows Server 2016[MAR 01]Auto-migration of Classic Outlook begins for Enterprise users (originally scheduled for April 2026, but postponed to March 2027)[OCT 12]SQL Server 2017
2029
[JAN 09]Windows Server 2019[OCT 09]Access 2024 | Outlook 2024[OCT 09(or later)]Classic Outlook- See "Edit 8/12/2024" at top of this article 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
2031
[OCT 14]Windows Server 2022
2033
[JAN 11]SQL Server 2022
2034
[OCT 10]Windows Server 2025
Ongoing
- Microsoft 365 (with subscription)
Date TBD
- Complete removal of VBScript from Windows OS (Microsoft Announces the Death of VBScript)