AP: Using cached ODBC connection in Access with single sign-on with Ron McCarry

Learn how to allow an Access application to connect to a SQL server database in such a way that only this one application can read/write to the database. Ron McCarry found quite a bit of information on using cached ODBC connections, but they all required the user to provide a username and password. Ron decided to provide the single sign-on convenience of Windows authentication but with application-level access control of SQL server authentication.
Ron will demonstrate the process in operation. The system went live in his organization in May of 2024 with 35 full-time users.
Links mentioned in the meeting and presentation.
What's New in Microsoft Access 2024:
support.micros...
Download the zip file with PPT, Sample accdb and Stored Procs:
accessusergrou...
Ben Clothier's original article on cached connections:
www.microsoft....
Other Links are in the presentation.

[@eduardoperezfernandez4151]

En mi caso no recomiendo por ningún motivo vincular tablas, utilizo PostgreSQL con alto nivel de seguridad, no obstante, excelente demostración. Mis felicitaciones

[@AccessUserGroups]

Thank you for your response. Please visit the AUG.com website, join a chapter and attend our presentations. accessusergroups.org/access-latino/

[@giorgiorovelli1542]

The link given at 7:00 doesn't lead to any Discord Server for Access Developers

[@AccessUserGroups]

Thanks for pointing that out. Apparently the link has now expired. We've used it for several months. I'll find the current link and add it to the description. In the meantime, try this temporary link. discord.gg/NDpfjb58