Juan Soto

About Juan Soto

Juan Soto is the President of IT Impact Inc., a Microsoft Access MVP for 14 consecutive years, and a database and AI consultant with over 32 years of experience. He specializes in Microsoft Access with SQL Server backends, helping businesses of all sizes design secure, stable, and scalable data environments. As AI tools continue to reshape the business landscape, Juan has expanded his expertise to help small businesses harness the power of artificial intelligence — from practical automation to smarter decision-making — making cutting-edge technology accessible without the enterprise price tag. A recognized voice in the Microsoft Access and AI communities, Juan is a frequent speaker at user groups and tech conferences nationwide and a sought-after podcast guest. He enjoys sharing practical insights on database architecture, AI integration, and modern business solutions with audiences of all technical levels. If you’d like Juan to speak at your next event, user group, or podcast, you can reach him here.
jsoto@itimpact.com

Using ADO Asynchronously in Microsoft Access to Speed up Forms

Using ADO Asynchronously in Microsoft Access to Speed up Forms Our presenter for the next meeting, on March 12th, is Ben Clothier.  Ben will talk to us about using ADO asynchronously in Access. Have you had scenarios where you need to load large amount of data but you don’t want to make users wait f [...]

2021-06-11T05:40:19-05:00March 10th, 2019|

Listen to the Microsoft Access Podcast Episode 1

Listen to the Microsoft Access Podcast Episode 1 I've launched a podcast focused exclusively on the business use cases of Access. I felt there was already plenty of technical information online but a real lack of great examples as to why Microsoft Access is an awesome alternative to other technologi [...]

2022-01-07T09:00:56-06:00March 6th, 2019|

Having Issues with MS Access Crashing? Try These Solutions First

Having Issues with MS Access Crashing? Try These Solutions First If your copy of Access is crashing please try the following strategies to get it stable again: Make sure your PC has the latest updates, including updates for Microsoft Office Verify your PC does not have a reboot pending after install [...]

2021-06-11T05:42:21-05:00February 28th, 2019|

Join us for the Microsoft Access with SQL Server Academy Part II

Join us for the Microsoft Access with SQL Server Academy Part II Our first session in September had a great turnout, for our next session on Tuesday December 11th at -6 UTC time, (6:30 PM Chicago CST), comes part 2 where we will cover: – Creating views and optimizing them – Table linking strategies [...]

2025-05-24T19:05:56-05:00December 5th, 2018|

Join Me with Special Guest Michal Bar from the MS Access Team!

Join Me with Special Guest Michal Bar from the MS Access Team! Join me tomorrow November 13th at 6:30 PM live via web conference as I host Michal Bar, Senior Program Manager for MS Access at our monthly AUG meeting, come hear the latest Access news and learn about the revamped Link Table Manager! Fo [...]

2021-06-11T05:45:32-05:00November 12th, 2018|

Join Me For a Microsoft Access with SQL Server Academy Session

Join Me For a Microsoft Access with SQL Server Academy Session We kick off the new season of Access with SQL Server group meetings this year with three months of training: Introduction, Intermediate and Advanced topics on how to optimize Access with SQL Server. Part 1: Introduction On Tuesday Septem [...]

2021-06-11T05:48:32-05:00September 9th, 2018|

Pitfalls to Avoid When Using the New Microsoft SSMA Version 7.8

Pitfalls to Avoid When Using the New Microsoft SSMA Version 7.8 Microsoft has been updating their SQL Server Management Assistants on a regular basis, and they just updated the SSMA for Access. However you can't see what's new for 7.8 in their official documentation. The latest version of SQL Server [...]

2021-06-11T05:49:24-05:00July 3rd, 2018|

Microsoft SQL Server – Join Me at SQL Saturday Dallas

Microsoft SQL Server - Join Me at SQL Saturday Dallas I'll be presenting my hugely popular "Wish you could live the glamorous consulting life?" first thing in the morning that day, plus I'll have a table where I'll be answering questions on SQL Server optimization with Access, if you are in the Dall [...]

2021-06-11T06:12:25-05:00May 12th, 2018|

Reasons to be Optimistic About the Future of Microsoft Access

Reasons to be Optimistic About the Future of Microsoft Access I’m just back from the recent PAUG conference where I had the chance to meet some of the best minds in Microsoft Access, it’s only one of two conferences worldwide, (Access DevCon Vienna is the other one), and it showcased some great cont [...]

2021-11-23T07:42:05-06:00May 7th, 2018|

How to Fix ‘System Resource Exceeded’ When Migrating to Windows 10

How to Fix 'System Resource Exceeded' When Migrating to Windows 10 System Resource Exceeded Error Message Lately we've been seeing a barrage of clients getting "System Resource Exceeded"  when migrating to Windows 10, even though the system worked fine in prior versions of Windows. In some cases we' [...]

2021-06-11T06:14:18-05:00April 22nd, 2018|

BREAKING NEWS: New Microsoft SQL Server Native Client 18 Released!

BREAKING NEWS: New Microsoft SQL Server Native Client 18 Released! As promised, the new SQL Server Native Client 18 is now available to download. Either Ben Clothier or I will be testing Azure authentication and other aspects of ADODB and be providing feedback soon! In the meantime, check out the an [...]

2021-06-11T06:15:09-05:00April 8th, 2018|
Go to Top