GPGeorge
George Hepworth
- Local time
- Today, 13:27
- Joined
- Nov 25, 2004
- Messages
- 2,460
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 1st 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.
Meeting ID: 852 1966 9601
Passcode: 123456
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 1st 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.
Join Zoom Meeting
If you are asked:Meeting ID: 852 1966 9601
Passcode: 123456
