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.

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 details please click here: https://www.sys.nl/netherlands [...]

NETHERLANDS ACCESS DEVELOPER DAY 2019 – 14 SEPTEMBER2019-08-08T09:08:35-05:00

Catch my presentation in Iowa next week, 3 cities in 3 days!

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 person: Access can be much faster with SQL Server, allowing many mor [...]

Catch my presentation in Iowa next week, 3 cities in 3 days!2019-08-08T11:07:15-05:00

Gotchas when using 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 runtime. It's not as easy as installing runtime [...]

Gotchas when using Access Runtime2019-07-19T09:31:11-05:00

Optimizing Access w/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. Abstract: SQL Server DBA’s are often asked to take over a Microsoft [...]

Optimizing Access w/SQL Server IndyPass 5/21/192019-05-16T07:30:00-05:00

Join me Tuesday April 9th for the latest Access news…

Fresh off my MVP Summit last week I’ll be discussing the latest on Microsoft Access. I’ll also be talking about the challenges of taking a product built on Access to the market. Join us! Tuesday April 9th at 630 PM CST (-5 UTC) https://accessusergroups.org/sql-server-with-access/event/375-2019-04-09 [...]

Join me Tuesday April 9th for the latest Access news…2019-04-06T10:47:58-05:00

Listen to Episode 2 of the Microsoft Access Podcast

This episode I’ve got more great examples of why Microsoft Access is great for business, listen and let me know your thoughts. Missed the first episode? You can find it here. [...]

Listen to Episode 2 of the Microsoft Access Podcast2019-04-01T08:22:18-05:00

Follow me on twitter during the MVP Summit next week

It’s time to visit the mother ship again, a yearly ritual both Ben and I relish as part of our MVP title, where the Microsoft Access team will share the latest, (often under NDA, sorry), I get to meet my peers from around the world and discuss all things Access. We also get lavished with gifts, (las [...]

Follow me on twitter during the MVP Summit next week2019-03-14T08:23:20-05:00

Using ADO asynchronously in 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 for it? We will cover how we can improve the responsiveness of t [...]

Using ADO asynchronously in Access to speed up forms2019-03-10T17:54:21-05:00

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 technologies. From highlighting the strengths of Access to [...]

Listen to the Microsoft Access Podcast Episode 12019-03-06T11:40:05-05:00

Having issues with 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 installing updates, (you will see "Update and Reboot" or "Update and Shu [...]

Having issues with Access crashing? Try these solutions first2019-02-28T08:07:03-05:00