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.

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

**BREAKING NEWS** NEW 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 announcement and other documents below : Announcement: bit.ly/SNC18 O [...]

**BREAKING NEWS** NEW SQL SERVER NATIVE CLIENT 18 released!2018-04-08T16:23:31-05:00

Help us get the IDE modernized in Access, your vote counts!

After my Access with SQL Server meeting were we talked about using User Voice to prompt change to our beloved IDE, I found out that the Access team does not have any sway over the environment, it's handled by the another group in the Office hierarchy. I’ve since endorsed the following ideas on User [...]

Help us get the IDE modernized in Access, your vote counts!2018-04-08T16:15:09-05:00

It’s time we gave the Access IDE some love

Quick: when  was the last time the Access Integrated Development Enviroment  (IDE) got a new feature? I can’t remember. While Access in general has gotten love from the Access team, in particular the new data connectors, its time we add SOME kind of new feature to the IDE, but which one?: Collapse p [...]

It’s time we gave the Access IDE some love2018-02-09T03:48:31-05:00

Inspect the control source of all controls in your project

Happy New Year! Recently I was working on a project where I was implementing form spawning so that my client can see at least two different records using two identical forms, one of the actual forms and the other one a spawned version of itself, (a topic I’ve discussed at my SQL Server with Access m [...]

Inspect the control source of all controls in your project2018-01-24T21:00:24-05:00

See you at the 2018 PAUG Conference

On Sunday - April 29, 2018 -, between 1:00 PM and 2:00 PM, I will be speaking at the annual PAUG Conference. Registration is open. Register now! Hurry, seats are limited & quickly sell out! This year promises to be the best! The dates for the PAUG 2018 Database Designer International Conference  [...]

See you at the 2018 PAUG Conference2018-06-27T20:25:12-05:00

OLE DB Undeprecated! Long live ADO!

The Microsoft SQLNCli team has undeprecated OLE DB and the news could very well be earth shattering for the Microsoft Access community. Previously deprecated and last supported with SQL Client 11, OLE DB was on it's last breaths, and what was worse, we could not come up with a equivalent solution us [...]

OLE DB Undeprecated! Long live ADO!2017-10-16T00:03:34-05:00

Our Microsoft Ignite session recording is now available to view!

Hello everyone! I just got back from Microsoft Ignite, where Michal Bar and I had a wonderful time presenting on "Learn new ways to apply Access to the modern Microsoft ecosystem". We discussed a few great topics, one of which is how to consume Azure services with Access. We should have the sample a [...]

Our Microsoft Ignite session recording is now available to view!2017-10-03T02:55:13-05:00

Meet Michal Bar and me at Microsoft Ignite!

This week Microsoft has invited me to speak at Microsoft Ignite along with Michal Bar from the Microsoft Access team! I'll be in Orlando all week learning about new technologies and on Wednesday afternoon present on how to plug Access into the modern Microsoft echo system in a 75 mins session.  If y [...]

Meet Michal Bar and me at Microsoft Ignite!2017-09-25T19:32:56-05:00

Updates from the Access team (June 2017)

New data connectors Announcement blog post on the Access blog. It has also been twitted here - feel free to retweet it! New in Microsoft Access: Microsoft Dynamics and Salesforce connectors. Learn more: https://t.co/NesijpM5uG — MS Office News (@OfficeNews) August 23, 2017 What’s New Article is upda [...]

Updates from the Access team (June 2017)2018-06-27T20:25:47-05:00
FREE CONSULT
close slider