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.

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: https://accessusergroups.org/microsoft-access-podcast/ [...]

Listen to Episode 2 of the Microsoft Access Podcast2019-03-16T20:45:09-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

Join us December 11th for 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 – SSMS tutorial Come join us for what promises to be a great laun [...]

Join us December 11th for Access with SQL Server Academy Part II2018-12-05T09:27:26-05:00

Join me on November 13 with a special guest: Michal Bar from the 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! For more info: https://accessusergroups.org/sql-server-with-acces [...]

Join me on November 13 with a special guest: Michal Bar from the Access team!2018-11-12T11:08:01-05:00

Join me for the first of three Access with SQL Server Acdemy sessions September 11 2018

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 September 11th 2018 I’m going to discuss: When you should or should n [...]

Join me for the first of three Access with SQL Server Acdemy sessions September 11 20182018-09-08T12:30:49-05:00

Join me at SQL Saturday Dallas on May 18th, 2018

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 Dallas area please consider attending this great one day e [...]

Join me at SQL Saturday Dallas on May 18th, 20182018-05-12T20:59:08-05:00

Why I’m optimistic about the future of 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 content over a three day period. This year’s conference had quite [...]

Why I’m optimistic about the future of Access2018-05-07T23:08:16-05:00

Getting “System Resource Exceeded” messages? Here’s one way to fix it

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've traced the issue to apps that use a lot of subforms in a tab con [...]

Getting “System Resource Exceeded” messages? Here’s one way to fix it2018-04-22T21:20:43-05:00
Contact Us
close slider
  • This field is for validation purposes and should be left unchanged.