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.
jsoto@itimpact.com

The State of Access in 2023

The future of Microsoft Access in 2023?  Earlier this year I was in Redmond, Washington, to participate in the MVP Summit, where I heard a lot about AI and Office and met with the Access team (it’s one of the best benefits to being an Access MVP). Although I can’t share much of what we discussed, I’ [...]

2023-06-06T10:34:48-05:00June 5th, 2023|

Can ChatGPT write VBA code? How about SQL Queries? Yes! But…

I've been playing with ChatGPT for a while now and mark me impressed with its capabilities. One of the first things I did was ask it to create a VBA function that calculates the first of the month: A couple of points on the code above: I never named the function yet the AI used a great name: FirstOf [...]

2023-01-24T17:32:01-06:00January 22nd, 2023|

Updating your SQL Drivers can be a pain, unless you do this

It seams Microsoft is releasing new drivers every few months now, trying to keep pace with the trove of new SQL Server and Azure features that come out with every new version. The drivers do double work, both with the product you can install locally, and the Azure service in the cloud. Why you shoul [...]

2022-12-04T11:59:26-06:00December 4th, 2022|

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 [...]

2022-10-26T16:05:33-05:00October 26th, 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|

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|

Avoid This Common Error When Executing Stored Procedure in MS Access

Avoid This Common Error When Executing Stored Procedure in MS Access   We love running stored procedures from our VBA code, but there is one issue you need to watch out for: Executing a procedure that affects data already loaded on your form. If you're not careful you will get the following [...]

2021-06-30T14:54:20-05:00March 2nd, 2021|

Easily Convert Your Microsoft Access Queries With This New Tool!

Easily Convert Your Microsoft Access Queries With This New Tool!   AccessUserGroups.org launched a new tool that will convert your Access queries over to TSQL: https://accessusergroups.org/blog/accesssqltool/ As a firm that specializes in converting Access to SQL Server, this tool will be a rea [...]

2021-06-11T04:20:49-05:00January 17th, 2021|
Go to Top