Week in Review: May 6, 2023
Highlights include automating DSN-less links to SQL Server, a deep dive on the form delete events, and the full release of the new Edge-based browser control.

Just Published
This section includes videos, articles, and interesting discussions from the past 7 days.
Articles
-
- Access Releases 2 Issue Fixes in Version 2304 (Released April 25, 2023), by Linda Lu Cannon
-
Ben Clothier (Access Experts)
-
Daniel Pineault (DEVelopers HUT)
-
Colin Riddington (Isladogs on Access)
- Password Login (with Session Login Information) (updated)
- Unblock downloaded files by removing the MOTW (updated)
- AEU15: Automate DSN-less Communication
- The Curious Case of the Multi Row Tab Control
- View Access Help (updated)
- Using the new VBA Project Signing feature - Part 1 (updated)
- Adding Security to Access Databases - A Wish List (updated)
- Securing Your Database - A Tutorial (updated)
-
Crystal Long (Ms Access Gurus | Access Access Newsletter)
-
Mike Wolfe (NoLongerSet)
Videos
-
Access User Group Recordings (YouTube channel)
- Automating DSN-Less Communication to SQL Server (1:01:23): by Peter Bryant
-
Crystal Long (YouTube channel)
- Report Drawing Reference (5:04)
-
Richard Rost (YouTube channel)
- Northwind 2 (7:22): Microsoft Access Northwind Traders v2 Template Now Available!
- User Level Security: Part 1 (26:44): How to Add Simple User-Level Security to Microsoft Access Databases
- User Level Security: Part 2 (15:52): Control Which Forms & Reports Users Can Open in Microsoft Access
- Data Types (23:00): Microsoft Access Data Types for Beginners
- Image Map (22:34): How to Use Transparent Buttons to Create an Image Map in Microsoft Access
- Company Logo (15:15): How To Add A Company Logo To Your Main Menu In Microsoft Access And Link It To Your Website
-
Daniel Pineault (YouTube channel)
- VBA - Hidden Members (6:15)
-
Pharos Technology [Dr. Richard Hanson] (YouTube MS Access playlist)
- Duplicate Records (Short): Finding Duplicate Records in a Flash
- Table Relationships (8:30): Creating and Managing Table Relationships in Microsoft Access
- Conditional Formatting (Short): Build a Visual Progress Tracking Board
- Table Validation Rules (8:47): Using Validations for Better Data Management
New to Me
This section includes content I discovered this week that has been around for awhile.
- [Quick Read]: All Programming Philosophies Are About State
- SQL Server Synonym: The Ultimate Guide to SQL Server Synonym By Practical Examples
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.
- May 9, 2023: Juan Soto - Selling Access Solutions - Part II
- May 18, 2023: Richard Rost - Custom Data Entry Filter Functions in Access
- May 30, 2023: Tom van Stiphout and Kim Young - Northwind 2.0
June 7, 2023: Thomas Pfoch - Maps for Microsoft Access- June 7, 2023: Tom van Stiphout- Introducing Northwind 2.0 (NEW SPEAKER AND TOPIC)
- June 15, 2023: Alessandro Grimaldi - "VBA Pills" - Access Tips and Tricks (JUST ADDED)
- July 5, 2023: Aleksander Wojtasz - Interactive Gantt Chart Scheduler in Access
- August 2, 2023: Thomas Möller - (topic details to follow)
- August 29, 2023: Lenni Lobel - Introduction to Azure Cosmos DB
- September 6, 2023: Juanjo Luna - Blazor: making a webApp
- October 4, 2023: Juan Soto - The Future of Access
- November 1, 2023: John Heaser - Extending Access with SQL Server – including Geography data
- December 6, 2023: Mike Wolfe - (topic to be confirmed)
Access Roadmap
There were NO CHANGES to the roadmap between the last Week in Review (2023-04-29) and this one (2023-05-06).
The development priorities were last updated on October 12, 2022.
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. 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.
New priorities added since the previous set of priorities are shown in bold below. Dropped priorities are struck through.
- Continued Focus on Monthly Issue Fixes (Monthly Issue Fix Blog)
- Inconsistent Database Error Fix
- New Macro Signing Support
- New (Modern) Web Browser Control (to support Chromium Edge)
- Dataverse Connector Data Type Support for Floating Point
- Dataverse Connector Data Type Support for Rich Text
- Dataverse Connector support to export to a specific Dataverse solution or publisher
Enabling Large Address Aware (LAA) for 32-Bit AccessSQL Monaco EditorNew Microsoft Graph Data Connector
In Development
APR 2023
: Modern Web Browser ControlMAR 2023
: New Modern Web Browser Form Control
Rolling Out
None.
Launched
None.
UPDATE [2023-05-08]: Corrected link to Crystal Long's "Report Gadgets" article.
A Libtard group (helping migrants travel) called Team Libertad?
It's like we're in a George Orwell novel.
"recently documented travelers" 🙄
From suitcases under tables to illegals under Atlanta. Our elections are secure.
they fly them in too. Somehow they get to Ireland and they are not crossing the English channel from Calais unless they are being helped from Dover, England to get to a port in Wales to make the crossing. It appears that the Kalergi Plan is what is driving this doctrine.
The Army unit patch appears to be the 194th Armored Brigade out of Ft Benning GA. This man swore an oath to defend the United States, and instead betrayed the entire nation. The US Military, in its entirety, supports and defends our enemies.
Vote Biden out.
Didn't work the first time.
Most latinos vote conservative....
LEGAL Latinos, illegals will vote for the party that offers amnesty.
Illegals dont have the right to vote....so wtf are u talkin about?
You expect the same people that piss all over border laws to respect voting laws?
It dont matter if they respect the voting laws....they cant vote...
Dim party mails them ballots, multiple to one address with the middle initial changed.
No....Thats not how it works....that has never happened...
"...Team Libertad..."
Um....that is a full anagram for 'tame libtarde'.
Am I high or is English the greatest language on the planet!
They always team this or team that.
Team Edward Team Jacob Team Libtard. 😆
Not just a soldier, a DRILL Sergeant , which seems to imply he is picking them up to go straight to basic training for instnat citizenship for them and their family.
Apocalyptos and ApeBeasts flooding Murica, YAY!
Aiding and abetting a federal offense, time for prison for all traitors to the American people. Or lead. Lead works too. Or a molotov thru their bedroom window at night,, that works for me as well..
"Your votes *coff I mean your lives matter." 🥔
Just democrats breaking constitutional law on "the downlow".
Traitors should hang.
Ur a moron....
They’re on the way to in massholechusetts, all that’s required is a drivers license.
Myorkas has hired Atlas air and Kalitta for logistics of transportation.
Bye bye US of A and the rest of white nations if this continues.
You know what they say about assumptions: I am.
I've never supported DT or JB or VP. But I definitely support your right to do so cause merica. Fuckya
Cry some more cracka....they are honkies just like u but have small hats....
Criminal alien invaders.
Until they are removed from all positions of power, the world has no chance at a future.
PKYS!
Our taxes at work
I bet all of you morons think that there's a network of FEMA death camps too..... A circle jerk of low IQ easily conned Trumptards.
Absolute bullshit. They never want you to see what they are doing. They know it is wrong but they do it anyway.
Im Just waiting until these "asylum seekers" pull off a "event"
It's just a matter of time
Naw. That is a Hamass tunnel if there ever was one.
BI DIM BITCH HAS DESTROYED THIS CUNTRY INTO
THE
NEXT MELENIUM
& WE WILL
PAY FROM HERE TO ETERNITY
& BECOME A
4TH WORLD COUNTRY. NO ONE VOTED FOR HIM
ALTHO THEY CLAIM NO ONES GOT SO MANY VOTES IN HISTORY
THATS BECAUSE THERE WERE MACHINES. IN THE LAST HR LAST DAY SPEWED
TWICE AS MANY VOTES THAN VOTERS
BY IRAN VENAZUELLA CHINA .................. ALL USER OF THESE CHEAT MACHINES WHO HATE.
AMERICA. & ADMISSION & COVER UPS
It will be just desserts if that liberal mainline church female in the blue shirt is offed by an illegal.
'under' eh? All the better to gas the bastards with impunity.
Yeah....but none of u crackas are geneticists....
Nah....im pretty sure that anglo honks are blacks biggest problem...
Don’t think that there has already been a ballot printed on their behalf.
This is the American version of a hamas terrorist tunnel.
Are u kidding me? Because the anglo crackas are the crackas that enslaved us, jim crowed us, black coded us, red lined us, emminent domained us, lynched us, stole our money, stole our land, etc....
Alien abductions taking place. Nothing to see here. Just extra Space Alien encounters. Hey Scotty beam me up their is no real life on this planet.
Seems to me that the soldier operating on us soil would be violating posse, commatatus also.