> ## 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: August 6, 2022 - URL: https://nolongerset.com/week-in-review-2022-08-06/ - Published: 2022-08-06T20:54:31.000Z - Updated: 2026-05-08T12:55:51.000Z - Description: Highlights include the list of Access fixes for Version 2206, a deep dive into how Access stores queries, and a rant against today's overly complicated forums. - Author: Mike Wolfe - Tags: Week in Review, #Import 2026-05-20 02:59 ## Just Published This section includes videos, articles, and interesting discussions from the past 7 days. #### Articles - *[New Access Fixes in Version 2206 (Released June 29)](https://techcommunity.microsoft.com/t5/access-blog/new-access-fixes-in-version-2206-released-june-29/ba-p/3592686)*, by Michael Aldridge - *[VBA to Draw Lines and Boxes on an Access Report](https://msaccessgurus.com/VBA/Draw%5FLine%5FBox.htm)*, by Crystal Long - [*ALERT: Broken semi-annual channel versions unable to export or output data – UPDATED*](https://accessexperts.com/blog/2022/08/04/alert-broken-semi-annual-channel-versions-unable-to-export-or-output-data/), by Ben Clothier - [*Azure mandating TLS 1.2 may break dependent .NET libraries*](https://accessexperts.com/blog/2022/08/05/azure-mandating-tls-1-2-may-break-dependent-net-libraries/), by Ben Clothier - [Access – Export to MySQL or Another RDMS](https://www.devhut.net/access-export-to-mysql-or-another-rdms/), by Daniel Pineault - [What Ever Happened to Simple Forums?!](https://www.devhut.net/what-ever-happened-to-simple-forums/), by Daniel Pineault - *UPDATED: [How Access Stores Queries - the MSysQueries table (Part 1 of 2)](https://isladogs.co.uk/explaining-queries/index.html)*, by Colin Riddington (now an Access MVP!) - [*Mama Mia! The Right Sauce Can Transform your Spaghetti-Like Data Into a 5-Star Performer*](https://www.linkedin.com/pulse/mama-mia-right-sauce-can-transform-your-data-5-star-performer-barnes/), by Maria Barnes #### Videos - **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD)) - [No Data](https://www.youtube.com/watch?v=85NJ5bxkOFI) (8:44): *On No Data Event. Displaying a Message if a Report Has No Records in Microsoft Access.* - [Secondary Emails](https://www.youtube.com/watch?v=UFAIlHZwPAo) (26:14): *Adding Secondary Email Addresses to Your Microsoft Access Database and Searching For Them!* - [Limit Size of Long Text](https://www.youtube.com/watch?v=IQnxFjL3CKk) (17:32): *Set a Maximum Size Limit for Long Text (Memo) Fields in Microsoft Access* --- ## New to Me This section includes content I discovered this week that has been around for awhile. - [*Private this As TSomething*](https://rubberduckvba.wordpress.com/2018/04/25/private-this-as-tsomething/), by Mathieu Guindon (Rubberduck VBA co-creator) - [*How to Close a Main Form Without Saving Changes of any Subforms*](https://bytes.com/topic/access/insights/951596-how-close-main-form-without-saving-changes-any-subforms), by Access MVP Adrian Bell --- ## 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/). - [September 1, 2022](https://accessusergroups.org/pacific/event/257-2022-09-01/): **Jack Stockton** \- Codifying Long Names into Unique Codes - [September 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-09-07/): **Colin Riddington** \- Optimizing Queries and the Use of JETSHOWPLAN - [October 5, 2022](https://accessusergroups.org/europe/event/access-europe-2022-10-05/): **Alessandro Grimaldi** \- Graphical Interfaces in Access - [October 6, 2022](https://accessusergroups.org/pacific/event/257-2022-10-06/): **Brian Krotine** \- Hosting Access Applications "in the cloud" - [November 2, 2022](https://accessusergroups.org/europe/event/access-europe-2022-11-02/): **George Hepworth** \- Power Apps for Access Developers - [December 7, 2022](https://accessusergroups.org/europe/event/access-europe-2022-12-07/): **Alexsander Wojtasz** \- Interactive Gantt Chart Scheduler in Access - [January 4, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less connections to SQL Server - [February 1, 2023](https://accessusergroups.org/europe/event/access-europe-2023-02-01/): **Thomas Möller** \- Better Access Charts --- ## Access Roadmap *There were *NO CHANGES* to the roadmap between last week (2022-07-30) and this week (2022-08-06).* Listed below is a snapshot of the [official Access Roadmap](https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=Access). "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. I'll include a link to the official Access blog post that lists 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, *[Changes to Our Public Roadmap and How We Communicate Access Feature Priorities](https://techcommunity.microsoft.com/t5/access-blog/changes-to-our-public-roadmap-and-how-we-communicate-access/ba-p/3329075)*. 1. Inconsistent Database Error Fix 2. New (Modern) Web Browser Control (to support Chromium Edge) 3. Enabling Large Address Aware (LAA) for 32-Bit Access 4. SQL Monaco Editor 5. New Microsoft Graph Data Connector #### In Development None. #### Rolling Out None. #### Launched - `MAY 2022`: Access Dataverse Connector - `JAN 2021`: Access: ODBC Interface Support (without ACE Redistributable Engine) - `JAN 2021`: Access: DAO Interface Support (without ACE Redistributable Engine)