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

I'm now an Access MVP!

Friends, family and blog readers: I've been named an Access MVP! It's the highest honor I can achieve in my field and I'm proud to wear the badge. With my accomplishment I join a brotherhood of professionals committed to promoting Access and helping others with their Access problems. There are only [...]

2011-10-04T09:41:22-05:00October 4th, 2011|

Special Presentation at CTAUG: "MS Access with SQL Server: Strategies and Tips"

I'll be presenting at CTAUG this month! Below are the details, would love to meet my blog readers in the area and have a great evenning of fun, Access and SQL Server in depth. Where: Microsoft Offices, Farmington, CT Pondview Corporate Center 74 Batterson Park Rd., #100 Farmington, CT 06032 (800) 67 [...]

2011-10-01T01:54:45-05:00October 1st, 2011|

Stored Procedure Guide for Microsoft Access – Part 2

This is part 2 in a multi-part series on Stored Procedures with Access, Part 1 can be found here and Part 3 here. In the first part of my guide I talked about using Pass Through queries as a convenient way to use Stored Procedures in Microsoft Access, in this second post I'm going to take it a step [...]

2021-03-18T07:06:33-05:00August 15th, 2011|

SQL Server doesn't work with Access? I beg to differ

I do post on Access forums when I can, in particular at UtterAccess.com's SQL Server forum. Many of you know SQL Server and Access are near and dear to me and I even travel the Country to speak at conferences about the two, advocating for the two as a great business solution. Recently I had the chan [...]

2011-08-10T10:33:31-05:00August 10th, 2011|

Presenting at SQL Saturday #79 – Free event!

I'll be presenting at SQL Saturday #79 in South Florida on August 13th! SQL Satuday is a full day of sessions focused on all things SQL, and it's free of charge! ($5 for lunch). Those of you in the South Florida/Fort Lauderdale/Miami area will have a great chance to enjoy many great sessions on SQL [...]

2011-08-01T23:23:46-05:00August 1st, 2011|

Winner Announced: Amazon gift card

Last month I wrote a three piece series on the Access IDE. If you read through the whole article you would have seen anyone posting a comment through the series they would be entered into a $25 giveaway after comments had been closed on the last post. Thanks for everyone who left a comment, the winn [...]

2011-06-13T07:36:35-05:00June 13th, 2011|

Use Batch Transactions with SQL Server to Guarantee Results

Batch transactions are a great way to avoid orphan records and to guarantee the database has performed all of the actions you have requested. This post will discuss how you can incorporate batch transactions in Access VBA using SQL Server. Why Batch? Normally you would use referential integrity and [...]

2011-06-06T17:47:26-05:00June 6th, 2011|

Introducing Ben Clothier

The IT Impact family is growing with the addition of Access MVP Ben Clothier as a Senior Access Developer. Ben has been developing for many years with Access and has an impressive list of accomplishments: He's been an Access MVP since 2009, based in part on his ground breaking work integrating Acces [...]

2011-05-31T21:28:47-05:00May 31st, 2011|
Go to Top