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

Please join us for our Monthly Chapter Presentation , at 6:30PM Pacific (UTC -8)

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 found quite a bit of information on using cached ODBC connections, but they all required the user to provide a username and password. Ron wanted 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 May of 2024.

About Ron McCarry

I have been working with Access since version 2. Before that I used Borland’s Paradox. Other versions were Access 97, Access 2010 and now Access365 x32 and x64. Most users have Access runtime installed. I also use C#, VB.net, AutoLisp, C and application specific macros.

I have a degree in computer science with a numerical methods emphasis. My family started Pack Air, Inc. in 1984 with me working in fabrication and assembly plus setting up the 1^st PC systems. Moved on to mechanical engineering and CAD adding code to simplify design.

Our existing commercial job cost system(s) had integration and usability limitations, so I added intermediate software which over 3 or 4 years ended up replacing most of the software’s functionality. Access was the obvious choice at the time. The Access applications now integrate with AutoCAD, Inventor, Autodesk Vault, Solidworks and Solidworks EPDM vault and the payroll and accounting software.

For fun, I enjoy camping, hiking, and kayaking with my wife of 27 years. Also working on and cruising in my 1969 Corvette.

Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.

AUG Access Pacific Calendar .ics file

==============================================================================

Please prepare ahead of time by downloading Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:

When it’s time, join the meeting from here:

Join Zoom Meeting

If you are asked: