Week in Review: August 9, 2025
Highlights include a simple fix for non-updateable queries, the 4th of a 4-part series on automatic form resizing, and more videos of the long-running fitness database build.

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.
- Jonathan Halder (Access JumpStart 2.0)
- Pair Programming Dreams and TDD Goals: A Personal Dev Update: Jonathan shares his renewed interest in Test-Driven Development and identifies three resources to help rebuild his TDD skills after feeling too busy programming to practice proper TDD techniques.
- Stuck with a Non-Updateable Query in Access? Try This Simple Fix: A practical workaround for non-updateable queries in Access by creating temporary tables to bypass aggregation-related update restrictions.
- Access Report Layouts: The Page Header Fix You Didn't Know You Needed: A technical solution for maintaining page numbering across all pages of an Access report while hiding page headers on specific sections using custom groups and VBA.
- Focus your Access skills: Jonathan emphasizes the importance of having a clear mission statement to guide daily work, using his own mantra of helping businesses simplify and streamline their operations.
- Version Control Systems and customer updates: Best practices for managing version control when customers want to modify Access databases, including sandbox strategies and recommendations against using multiple development teams.
- Colin Riddington (Isladogs on Access)
- Automatic Form Resizing - Part 4 (of 4): Final part of a series covering advanced features like manual override capabilities, design view zoom scaling, and comprehensive testing of the automatic form resizing system.
- AEU42: New and Forthcoming Features in Access: Demonstrates recently released Access features including VBA support for modern charts and Monaco SQL editor improvements, plus upcoming responsive forms and large monitor support features.
- Mike Wolfe (NoLongerSet)
- AI Assistants with Alexander Denz: Comprehensive overview of Alexander Denz's two generations of AI add-ins for Microsoft Access that bring ChatGPT-level intelligence and custom knowledge bases directly into the development environment.
- Throwback Thursday: August 7, 2025: Weekly feature revisiting standout posts about Access's hidden WizHook object and its various capabilities for font-aware AutoFit, message boxes with bold text, and array sorting.
Videos
- Richard Rost (YouTube channel)
- Quick Queries #52 (25:12): Using GUIDs Across Databases, Calculated Fields in Tables
- Microsoft Access Fitness Database:
New to Me
This section includes content I discovered this week that has been around for a while.
- Nothing new this week.
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. 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.
IMPORTANT NOTE: As of publication, the AccessUserGroups.org website was returning a 404 error. The information below is copied from last week's article.
- [August 26, 2025] Maria Barnes: Update on calling Microsoft Graph API from VBA
- [September 03, 2025] Adam Waller: Version Control for the Sole Developer – Why it Matters
- [September 04, 2025] Greg Regan: Updated Control Tip Text
- [September 30, 2025] Crystal Long & Adrian Bell: Using Custom and Built-in Functions in Expressions
- [October 01, 2025] Marcus Dieterle: High impact – Custom dialogs and mini-notifications
- [November 05, 2025] Aleksander Wojtasz: Topic TBD
- [December 03, 2025] Adolph Dupré: Topic TBD
- [January 07, 2026] Ynte Jan Kundersma: Using Power Automate with Office Apps
- [March 04, 2026] Chris Arnold: Using Disconnected (In-Memory) ADO Recordsets in Access
Access Roadmap
The following changes were made to the roadmap between the Week in Review last week (2025-08-02) and this week (2025-08-09):
- The previously completed feature–Modern Chart Improvements–which began rolling out in August 2024, was removed from the online roadmap this past week.
The roadmap was last updated the week of August 3, 2025. The development priorities were last updated at the German-language AEK conference on October 20, 2024.
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.
"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.
Development Priorities
The items listed below reflect Microsoft's order of priority and were published in the following article, Microsoft's Plans for Access Oct '24 – March '25.
The items are listed in priority order according to Principal Engineering Manager Dale Rector. The "Expected Benefit" of each feature is shown in italics after the description of the feature itself.
New priorities added since the previous set of priorities are shown in bold below.
- Continued Focus on Monthly Issue Fixes: (Monthly Issue Fix Blog) Improved product quality and reliability
- Large monitor support for forms: Improved support of Access on the latest hardware
- Integrated source control: Simplifying the process of building mission critical Access solutions
Special thanks to Karl Donaubauer for posting the updated priorities at AccessForever.org.
In Development
SEP 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.SEP 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
NOTE: Dates listed are rollout start dates.
SEP 2024
: Integrate Monaco framework to improve SQL editor capabilities: The Monaco Editor is the fully featured code editor from VS Code with standard IDE functionality such as syntax highlighting, IntelliSense, and autocomplete.
Upcoming End-of-Life Dates
Here are the key end-of-life dates Access developers should track:
2024
Teams Classic Client[JUL 01]
SQL Server 2014[JUL 09]
Auto-migration of Classic Outlook begins for personal accounts[OCT 01]
Windows 11 version 22H2[OCT 08]
2025
Auto-migration of Classic Outlook begins for Small/Medium Business users[JAN 01]
[OCT 14]
Access 2016 | Access 2019 | Office 2016 | Office 2019[OCT 14]
Windows 10[NOV 11]
Windows 11 version 23H2
2026
[APR 01]
Auto-migration of Classic Outlook begins for Enterprise users[JUL 14]
SQL Server 2016[OCT 13]
Access 2021 | Office 2021[OCT 13]
Windows 11 version 24H2
2027
[JAN 12]
Windows Server 2016[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)