> ## 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: November 4, 2023
- URL: https://nolongerset.com/week-in-review-2023-11-04/
- Published: 2023-11-04T21:15:40.000Z
- Updated: 2026-05-08T12:36:39.000Z
- Description: Highlights include Karl's Access News update, Access learning resources, SQL Server with geography data, and the coming death of VBScript.
- 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

- **a.p.r. pillai** ([Learn MS-Access Tips and Tricks](https://www.msaccesstips.com/))

  - [Streamlining Form VBA External Files List HyperLinks](https://www.msaccesstips.com/2023/10/streamlining-form-vba-external-files.html)
- **Crystal Long** ([Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/))

  - [Two free tools that run in Access: (1) List Objects from Access databases and (2) VBA Code Documenter for Access, Excel, Word, and PowerPoint](https://www.linkedin.com/pulse/two-free-tools-run-access-1-list-objects-from-2-vba-strive4peace--6i8zc/)
- **Colin Riddington** (*[Isladogs on Access](https://isladogs.co.uk/home/index.html)*)

  - [Open Database with Shift Bypass using Code - Pg 1](https://isladogs.co.uk/open-shift-bypass/index.html)
  - [Open Encrypted Database with Shift Bypass - Pg 2](https://isladogs.co.uk/open-shift-bypass-2/index.html)
  - [Manage the Shift Bypass Property - Pg 3](https://isladogs.co.uk/open-shift-bypass-3/index.html)
  - [Access News VIDEO - AEK Conference (Oct 2023)](https://isladogs.co.uk/access-news-7/index.html)
  - [AEU21: Use SQL Geography data in Access](https://isladogs.co.uk/aeu-21/index.html) *(updated)*
  - [Manage Totals row using VBA](https://isladogs.co.uk/totals-row-vba/index.html)
  - [Open Queries Directly in SQL View](https://isladogs.co.uk/query-sql-view/index.html)
  - [Two Font Display Bugs in Version 2309 - FIXED](https://isladogs.co.uk/font-display-bugs-2309/index.html) *(updated)*
- **Crystal Long** (*[Ms Access Gurus](https://msaccessgurus.com/Articles.htm) | [Access Access Newsletter](https://www.linkedin.com/newsletters/access-access-6948757551320633344/)*)

  - [Code Documenter for VBA7](https://msaccessgurus.com/tool/CodeDocumenter.htm)
- **Mike Wolfe** (*[NoLongerSet](https://nolongerset.com/)*)

  - [Creating and Editing Import Specifications via the Wizard](https://nolongerset.com/import-specs-via-the-wizard/)
  - [UserPressed(): Break Out of a Long-Running Loop in VBA with the Escape Key](https://nolongerset.com/userpressed/)
  - [Microsoft Announces the Death of VBScript](https://nolongerset.com/vbscript-deprecation/)
  - [Local vs. Linked Tables in Microsoft Access](https://nolongerset.com/local-vs-linked-tables-in-access/)
  - [Documenting Recurring Processes](https://nolongerset.com/documenting-recurring-processes/)

#### Videos‌

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

  - [Using SQL Server to extend Access - including Geography data](https://www.youtube.com/watch?v=UMbe0SsqrfM) (52:03): *with John Heaser*
- **Denver Area Access Users Group** ([YouTube channel](https://www.youtube.com/@DAAUG))

  - ["VBA Pills" - Access Tips and Tricks](https://www.youtube.com/watch?v=uLH1iD6RJ5g) (55:30): *with Alessandro Grimaldi*
- **Karl Donaubauer** ([YouTube channel](https://www.youtube.com/@karldonaubauer6898))

  - [Access News: Edition 7](https://www.youtube.com/watch?v=aKqZX4eE5NA) (20:06): *October 2023*
- **George Hepworth** ([YouTube channel](https://www.youtube.com/@GroverParkGeorge))

  - [Building the LTF Searchable Catalog, Part 9](https://www.youtube.com/watch?v=%5FGwgR3bwfEY) (11:12): *PowerApps Formulas, Public Constant*
- **Richard Rost** ([YouTube channel](https://www.youtube.com/@599CD))

  - [Access as a Database Server](https://www.youtube.com/watch?v=-Qu5obDLji0) (15:20): *Part 1*
  - [Access as a Database Server](https://www.youtube.com/watch?v=hPdcRJao5rI) (16:15): *Part 2*
  - [Access as a Database Server](https://www.youtube.com/watch?v=fc5nMHF9elE) (15:46): *Part 3*
  - [Access as a Database Server](https://www.youtube.com/watch?v=BmVS3aNs7mk) (15:10): *Part 4*
  - [Access as a Database Server](https://www.youtube.com/watch?v=VUj6G5FVod0) (16:17): *Part 5*
- **Daniel Pineault** ([YouTube channel](https://www.youtube.com/@DanielPineault))

  - [Microsoft Announces the Death of VBScript](https://www.youtube.com/watch?v=o7Kc81LbCg0) (03:55)
  - [Microsoft Access - Where To Start Learning](https://www.youtube.com/watch?v=023CFfX%5FhME) (16:06)
- **Pharos Technology \[Dr. Richard Hanson\]** ([YouTube channel](https://www.youtube.com/@PharosTechnology))

  - [Connect to Any Database](https://www.youtube.com/watch?v=8Px8tmCVwsw) (14:03): *4 Quick and Easy Ways to Connect to Backend Databases*

---

## New to Me

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

*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](https://accessusergroups.org/calendar/).

- [November 16, 2023](https://www.daaug.org/Presentations/Details/256): **Alexander Denz** \- ChatGPT in Access
- [November 22-23, 2023](https://ukaug.co.uk/next-conference/): (IN-PERSON!) UK Access User Group Conference (at the offices of Gordon Associates in Cheltenham)
- [December 6, 2023](https://accessusergroups.org/europe/event/access-europe-2-2023-12-06/): **Mike Wolfe** \- Streamline Your Import/Export Spec Workflow with VBA Classes
- [January 3, 2024](https://accessusergroups.org/europe/event/access-europe-2024-01-03/): **Ramachandran (A.P.R.) Pillai** \- Streamlining the Form Module Code in the standalone Class Module
- [February 7, 2024](https://accessusergroups.org/europe/event/access-europe-2024-02-07/): **Carlos Quintero** \- Features of MZ-Tools to make you more productive with VBA
- [March 6, 2024](https://accessusergroups.org/europe/event/access-europe-2024-03-06/): **Thomas Möller** \- Better Access Charts in the new Edge Browser Control
- [April 3, 2024](https://accessusergroups.org/europe/event/access-europe-2024-04-03/): **Dale Fye -** Working with Command Bars and the Access Shortcut Tool
- [May 1, 2024](https://accessusergroups.org/europe/event/access-europe-2024-05-01/): **Colin Riddington** \- View & Edit Import/Export (IMEX) Data Task Specifications

---

‌

## Access Roadmap

*There were *NO CHANGES* to the roadmap between the last Week in Review (2023-10-28) and this one (2023-11-04).*

*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

- `NOV 2023`: Making 32-bit Access [Large Address Aware](https://nolongerset.com/laa-flag/) (LAA)

#### Rolling Out

None.

#### Launched

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