Juan Soto

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.
jsoto@itimpact.com

Access Experts’ View on the 2020 MVP Summit

Access Experts' View on the 2020 MVP Summit   Last week we had our virtual MVP conference, where I huddled with MVP’s from around the world as we heard and gave feedback to the Access team. Here are some takeaways: I miss sharing with friends I only get to see once a year, but being virtual did [...]

2021-06-11T05:20:26-05:00March 25th, 2020|

New Microsoft Access Features Coming Your Way!

New Microsoft Access Features Coming Your Way!   Never discount looking at the What’s New section in Microsoft Office to get a first hand look at goodies coming your way! A fellow MVP pointed out to me how you can see new features by going to backstage, (File menu), clicking on Account and then [...]

2021-06-11T05:21:30-05:00February 28th, 2020|

Learn How to Performance Tune Microsoft SQL Server

Learn How to Performance Tune Microsoft SQL Server   Please join me on February 11th, 2020 when I'll have special guest Jacob Golden from https://www.imyourdba.com/ to discuss how you can improve the performance of your database on SQL Server, can't miss talk! Learn more here: https://accessuse [...]

2021-06-11T05:25:04-05:00February 7th, 2020|

The Microsoft Office Product That Refuses to Die

The Microsoft Office Product That Refuses to Die Several of you have sent me an article on Medium.com asking my thoughts on it: Microsoft Access: The Database Software That Won’t Die I agree with some points and am amazed that the author completely missed one point in particular. Access is sooo easy [...]

2021-06-11T05:27:47-05:00November 9th, 2019|

You Can Now Use Access with Microsoft Azure MFA!

You Can Now Use Access with Microsoft Azure MFA! With the latest release of the OLE DB driver Access developers can now implement Azure multi factor security into their applications, (previously the latest version of SQL Server ODBC was the only supporting the technology), allowing them to run code [...]

2021-06-11T05:28:49-05:00October 31st, 2019|

7 Step Guide to Using Access with Azure Multi-Factor Authentication

7 Step Guide to Using Access with Azure Multi-Factor Authentication One of our clients wanted to use Azure multi-factor authentication with Microsoft Access and Azure SQL, requiring users to authenticate when they launch Access through a second validation at least once every 60 days. Step 1: Extend [...]

2021-06-11T05:29:42-05:00October 3rd, 2019|

Microsoft Access is NOT Dead and Neither is VBA

Microsoft Access is NOT Dead and Neither is VBA Catch my latest podcast on why Access is not dead! Episode 1: Introduction to the podcast Episode 2: More great examples of why Microsoft Access rocks for business Episode 3: Why Microsoft Access is NOT going away Episode 4: Best practices for Microsof [...]

2022-01-07T09:06:01-06:00August 17th, 2019|

Netherlands Access Developer Day 2019 – 14 September

Netherlands Access Developer Day 2019 – 14 September Access developer day is quickly approaching and you still have time to register and get a discount. It promises to be a great experience with the Access team and some of the brightest Access developers in the world. To register and learn more deta [...]

2021-06-11T05:32:18-05:00August 8th, 2019|

Catch my ‘Optimizing Microsoft Access with SQL Server’ Presentation

Catch my 'Optimizing Microsoft Access with SQL Server' Presentation Next week August 12, 13 and 14th I will be doing a different SQL Server PASS group each night in Iowa, it’s the perfect opportunity for you to catch my “Optimizing Access with SQL Server” presentation if you live nearby live and in [...]

2021-06-11T05:33:14-05:00August 6th, 2019|

Gotchas When Using Microsoft Access Runtime

Gotchas When Using Microsoft Access Runtime We've noticed more firms migrating over to Office365 and it's liberal policies of 5 licenses per user, but there are still instances were providing an office license is too expensive for a mission critical application, prompting many to use the Access runt [...]

2021-06-11T05:33:54-05:00July 19th, 2019|

Optimizing Microsoft Access with SQL Server IndyPass – 5/21/19

Optimizing Microsoft Access with SQL Server IndyPass - 5/21/19 Join me on Tuesday May 21st 2019 as I present Optimizing Access with SQL Server to the great folks at IndyPass. I’ll be discussing all the great tips and techniques we use with clients around the world. Pizza will be served as well. Abst [...]

2021-06-11T05:34:40-05:00May 16th, 2019|
Go to Top