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

No meeting tomorrow, join me on December 13th

I am currently traveling through the Middle East on a entrepreneurship training course through Israel where I’m meeting startups and getting a ton of ideas for my practice. Consequently we will not be having our normal meeting in November and our next meeting is in December 13th 2022. Here are the m [...]

2022-11-07T10:39:02-06:00November 6th, 2022|

How I bombed at my last presentation – yes, it happens to all of us

Last Tuesday, October 11, 2021 I was all set to present SQL Server with Access Academy Part II when I hit a roadblock I could not overcome: SQL Server Migration Assistant for Access, (SSMA), would not load the sample Northwind database and I was stuck, could not continue the session. I've done it fo [...]

2025-05-25T18:19:06-05:00October 26th, 2022|

Identifying and Managing Mission-Critical Access Applications During a Development Project

During your Access development project, it is important that you identify mission-critical Access applications. These are the Access databases that are crucial to the success of your project and your business as a whole. If these applications are not functioning properly and you have no idea how to [...]

2022-05-20T05:14:37-05:00May 6th, 2022|

6 Reasons Microsoft Access Can Help Your Business

Almost every business in the world uses Microsoft Excel. For creating simple spreadsheets, it’s probably the best piece of software in the world. But as a company grows and spreadsheets become more complicated, Excel will show its limitations. This is where Microsoft Access comes in. When your comp [...]

2022-04-19T03:46:49-05:00March 24th, 2022|

*ALERT* Windows update breaks pure Access applications – fix available

We've gotten reports of an Office update adversely impacting existing applications that uses Access database to store data and is shared on a network location. Because of the update, people no longer can connect to same Access database file. With the update, only one can use the shared Access databa [...]

2022-05-06T09:02:04-05:00December 20th, 2021|

Access dataverse connector is now available to test

The Access team has released a new test version that includes a dataverse connector, from Michael Aldridge, program manager from for Access: Hello Microsoft Access community ! I am excited to let you all know we shipped the public beta of the Access Connector for Dataverse and Power Platform at Igni [...]

2022-04-19T03:57:43-05:00November 9th, 2021|

7 Ways Microsoft Access Can Help Your Business

7 Ways Microsoft Access Can Help Your Business Almost every business in the world uses Microsoft Excel. For creating simple spreadsheets, it’s probably the best piece of software in the world. But as a company grows and spreadsheets become more complicated, Excel will show its limitations. This is w [...]

2022-04-19T03:58:50-05:00August 3rd, 2021|

When should you use SQL Server with Access? (Hint: Almost always)

[Update] Post has been updated to correct the maximum size of the database to 10 Gigs When should you use SQL Server with Access? (Hint: Almost always) Look, I’ve heard the phrase “When all you have is a hammer everything looks like a nail” and given that our specialty is Access with SQL Server at I [...]

2021-11-09T17:35:51-06:00August 1st, 2021|

Check Out the Latest News on Microsoft Access, Including Access 2022!

Check Out the Latest News on Microsoft Access, Including Access 2022!   Check out all the BREAKING NEWS Ebo Quansah released at my last Access with SQL Server meeting: https://accessusergroups.org/blog/the-biggest-news-from-ebo-quansahs-march-9th-2021-presentation/ #msaccess Access MVP Summit T [...]

2021-06-11T04:19:18-05:00March 29th, 2021|
Go to Top