isladogs
Access MVP / VIP
- Local time
- Today, 10:56
- Joined
- Jan 14, 2017
- Messages
- 19,538
@mellamokb
The HKCU registry path is now working in the latest Beta release 2604 19916.20000 released 2026-03-19 and may by now also be in Current Channel (Preview). More importantly, it will also be in Current Channel version 2603 when that is released around the end of this month.
The registry path is: HKCU\Software\Microsoft\Office\16.0\Access\Access Connectivity Engine\Engines\AllowQueryRemoteTables
Further info:
The HKCU registry path is now working in the latest Beta release 2604 19916.20000 released 2026-03-19 and may by now also be in Current Channel (Preview). More importantly, it will also be in Current Channel version 2603 when that is released around the end of this month.
The registry path is: HKCU\Software\Microsoft\Office\16.0\Access\Access Connectivity Engine\Engines\AllowQueryRemoteTables
Further info:
- This HKCU value will take precedence over the other HKLM locations previously supplied.
- The HKCU value will NOT be removed when an Office update occurs.
- Public documentation will be updated to reflect this.
- As it is now in HKCU, the value can be set using VBA by your Access app without requiring admin privileges