> ## 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 25, 2023
- URL: https://nolongerset.com/week-in-review-2023-03-25/
- Published: 2023-03-25T15:34:41.000Z
- Updated: 2026-05-08T12:50:53.000Z
- Description: Highlights include integrating better Access charts, a Table Analyzer and Viewer utility, SQL Server security deep dive, and opening external files and URLs from VBA.
- 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

- **[Access Forever](https://www.accessforever.org/)**

  - [Access DevCon 2023, Agenda+Schedule](https://www.accessforever.org/post/access-devcon-2023-agenda-schedule), *by Karl Donaubauer*
- **Crystal Long** ([Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/))

  - [Font List -- automate Word from Access](https://www.linkedin.com/pulse/font-list-automate-word-from-access-crystal-strive4peace-/)
- **Daniel Pineault** (*[DEVelopers HUT](https://www.devhut.net/)*)

  - [VBA – Validate If A URL Exists](https://www.devhut.net/vba-validate-if-a-url-exists/)
  - [VBA – Determine URL Redirect Address](https://www.devhut.net/vba-determine-url-redirect-address/)
  - [Access – List of Bugs](https://www.devhut.net/access-list-of-bugs/)
  - [Access DevCon 2023 Is Around The Corner!](https://www.devhut.net/access-devcon-2023-is-around-the-corner/)
  - [Update Crosstab Query’s Subform To Reflect New Fields](https://www.devhut.net/update-crosstab-querys-subform-to-reflect-new-fields/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [Compare Control Help Text Methods](https://isladogs.co.uk/control-help/index.html) *(UPDATED)*
  - [Table Analyzer & Viewer](https://isladogs.co.uk/table-analyzer/index.html)
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [Word Field Shading](https://msaccessgurus.com/VBA/Word%5FFieldShading.htm)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Five Problems Working with Global Constants in VBA](https://nolongerset.com/global-constant-problems/)
  - [Testing Non-Privileged Access to SQL Server During Development](https://nolongerset.com/testing-with-bobbyt/)
  - [Creating a Low-Privileged Local User for SQL Server Testing](https://nolongerset.com/bobbyt/)
  - [Final Lineup Announced for Access DevCon Vienna 2023](https://nolongerset.com/devcon-lineup-2023/)
  - [Why Do I Need to Set Objects to Nothing in VBA?](https://nolongerset.com/setting-objects-to-nothing/)

#### Videos‌

- **Access User Group Recordings** ([YouTube channel](https://www.youtube.com/c/AccessusergroupsOrg))

  - [SQL Server with Access Academy Part V - Security with SQL Server and Access With Juan Soto](https://www.youtube.com/watch?v=OXNzrTc96LU) (59:27): *by Juan Soto*
- **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/channel/UCNNOZWYonWCgsqznH33QpvQ))

  - [Integrating Better Access Charts into an Application](https://www.youtube.com/watch?v=TJaYFXIIVVc&t=9s) (1:21:12): *by Phil Ferrero*
- **Colin Riddington \[Isladogs\]** ([YouTube channel](https://www.youtube.com/channel/UCLqpE3bfxr1gLc%5FOOM1ToUA))

  - [Access Table Analyzer and Viewer](https://www.youtube.com/watch?v=BPO%5FxgvbxPY) (8:16)
- **Richard Rost** ([YouTube channel](https://www.youtube.com/c/599CD))

  - [Percent Bug!](https://www.youtube.com/watch?v=1NnW-5yKfxE) (14:37): *Bug or Feature? Demystifying Percentage Data Entry in Microsoft Access: Tips and Workarounds*
  - [Replication ID](https://www.youtube.com/watch?v=vByUQ2bRSmc) (12:01): *What is a Replication ID in Microsoft Access and When Would I Use One?*
  - [Disable AutoSave](https://www.youtube.com/watch?v=LpFpacVWUp8) (16:23): *How to Disable Automatic Record Saving in Microsoft Access*
  - [Database Launcher](https://www.youtube.com/watch?v=zwACQ5TyMZI) (14:34): *Create a Database Launcher that Opens Other Microsoft Access Databases*
  - [ChatGPT VBA Code](https://www.youtube.com/watch?v=i1oO2sXsf1I) (9:33): *Enhance Your Microsoft Access Database with ChatGPT-Generated VBA Code*
  - [r/MSAccess](https://www.youtube.com/watch?v=n7gv9xxHcW4) (1:42): *An Excellent Resource for Microsoft Access Help & Assistance: Reddit r/MSAccess*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/channel/UC9lSC6AT4d0qour-aIbMjFQ))

  - [Opening External Files and URLs](https://www.youtube.com/watch?v=1giorHF6Yvg) (12:39)

---

## New to Me

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

- *[Syntax, Semantics, Micronesian cults and Novice Programmers](https://learn.microsoft.com/en-us/archive/blogs/ericlippert/syntax-semantics-micronesian-cults-and-novice-programmers)*, by [Eric Lippert](https://stackoverflow.com/users/88656/eric-lippert)
- *[COM Registration](https://github.com/rubberduck-vba/Rubberduck/wiki/COM-Registration)*, by Ben Clothier
- *[Something Pretty Right: The History and Legacy of Visual Basic](https://retool.com/visual-basic/)*, by Ryan Lucas

---

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

- [March 28, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-03-28/): **Maria Barnes** \- Explore the new Edge Web Browser control in Insiders (**JUST ADDED**)
- [April 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-04-05/): **Duane Hookom** \- Creating calendar format reports
- [April 6, 2023](https://accessusergroups.org/pacific/event/migrating-access-tables-to-sql-server-a-comparison-of-methods/): **Tom Wickerath and George Hepworth** \- Migrating Access Tables to SQL Server, a Comparison of Methods
- [April 20, 2023](https://www.daaug.org/Presentations/Details/250): **Tom van Stiphout** \- Northwind 2.0 Is Here! (**JUST ADDED**)
- [April 25, 2023](https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-04-25/): **Maria Barnes** \- What's New with Access?
- [April 27-28, 2023](https://www.donkarl.com/devcon/): **Access DevCon Vienna**
- [May 3, 2023](https://accessusergroups.org/europe/event/access-europe-2023-01-04/): **Peter Bryant** \- Automating DSN-less Communications to SQL Server
- [June 7, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-06-07/): **Thomas Pfoch** \- Maps for Microsoft Access
- [July 5, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-07-05/): **Aleksander Wojtasz** \- Interactive Gantt Chart Scheduler in Access
- [August 2, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-08-02/): **Thomas Möller** \- (topic details to follow)
- [September 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-09-06/): **Juanjo Luna** \- Blazor: making a webApp
- [October 4, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-10-04/): **Juan Soto -** The Future of Access
- [November 1, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-11-01/): **John Heaser** \- Extending Access with SQL Server – including Geography data
- [December 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-12-06/): **Mike Wolfe** \- (topic to be confirmed)

---

‌

## Access Roadmap

*There were *NO CHANGES* to the roadmap between the last Week in Review (2023-03-18) and this one (2023-03-25).*

*The [development priorities](https://techcommunity.microsoft.com/t5/access-blog/our-road-ahead-microsoft-access-engineering-priorities-oct-2022/ba-p/3651894) were last updated on October 12, 2022.*

---

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, *[Our Road Ahead - Microsoft Access Engineering Priorities Oct 2022](https://techcommunity.microsoft.com/t5/access-blog/our-road-ahead-microsoft-access-engineering-priorities-oct-2022/ba-p/3651894)*.

New priorities added since the [previous set of priorities](https://techcommunity.microsoft.com/t5/access-blog/changes-to-our-public-roadmap-and-how-we-communicate-access/ba-p/3329075) are shown in bold below. Dropped priorities are struck through.

1. **Continued Focus on Monthly Issue Fixes** *(Monthly Issue Fix Blog)*
2. Inconsistent Database Error Fix
3. **New Macro Signing Support**
4. New (Modern) Web Browser Control (to support Chromium Edge)
5. **Dataverse Connector Data Type Support for Floating Point**
6. **Dataverse Connector Data Type Support for Rich Text**
7. **Dataverse Connector support to export to a specific Dataverse solution or publisher**
8. ~~Enabling Large Address Aware (LAA) for 32-Bit Access~~
9. ~~SQL Monaco Editor~~
10. ~~New Microsoft Graph Data Connector~~

#### In Development

- `APR 2023`: Modern Web Browser Control
- `MAR 2023`: New Modern Web Browser Form Control

#### Rolling Out

None.

#### Launched

None.