fbpx

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

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

*ALERT* Windows update breaks pure Access applications – fix available2021-12-20T05:32:12-06:00

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

Access dataverse connector is now available to test2021-11-09T18:04:39-06:00

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

When should you use SQL Server with Access? (Hint: Almost always)2021-11-09T17:35:51-06:00

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

Check Out the Latest News on Microsoft Access, Including Access 2022!2021-06-11T04:19:18-05:00

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

Avoid This Common Error When Executing Stored Procedure in MS Access2021-06-30T14:54:20-05:00

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

Easily Convert Your Microsoft Access Queries With This New Tool!2021-06-11T04:20:49-05:00

Where to Download the Runtime Kit for Microsoft Access 2016

Where to Download the Runtime Kit for Microsoft Access 2016   If you ever need to download the runtime kit for Access 2016 you will find it here: https://www.microsoft.com/en-us/download/details.aspx?id=50040 If you expand the Details section you will see the following note: Note: There are mul [...]

Where to Download the Runtime Kit for Microsoft Access 20162022-01-07T09:07:58-06:00

Join Us for an Intro to Access with SQL Server

Join Us for an Intro to Access with SQL Server   On Tuesday September 8th, 2020 at 6:30 PM CST we are back from summer vacation to start the new season! We will start with introduction to Access with SQL Server, you can learn more at https://accessusergroups.org/sql-server-with-access/event/375 [...]

Join Us for an Intro to Access with SQL Server2021-06-11T05:03:15-05:00

How to Consistently Earn a Microsoft Access MVP Award

How to Consistently Earn a Microsoft Access MVP Award   I often get asked, "how does one become an Access MVP?" 9 Years of MVP Awards When I first started nine years ago, we had over 30 MVPs. Now we have less than 20. Each year, I need to compile my accomplishments and submit them for review, [...]

How to Consistently Earn a Microsoft Access MVP Award2021-06-11T05:04:24-05:00

How to Fix the New Data Type That is Causing Problems to MS Access

How to Fix the New Data Type That is Causing Problems to MS Access   [UPDATE: now with Access team link to fixes] Recently the Access team starting working on a new data type called Date & Time Extended, here’s Ebo Quansah, Access program lead: Very soon, we will ship a new data type, known [...]

How to Fix the New Data Type That is Causing Problems to MS Access2021-06-11T05:15:14-05:00

Free Field Hospital Database to Fight the COVID-19 Pandemic

Free Field Hospital Database to Fight the COVID-19 Pandemic Field Hospital Inventory System During these grave times we see field hospitals going up everywhere: Central Park in New York, churches, gyms, parking lots, and more. The COVID Supplies Database is our way of helping humanity in this time o [...]

Free Field Hospital Database to Fight the COVID-19 Pandemic2022-01-07T09:07:07-06:00
Go to Top