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

Thinking about hosting your SQL Server database on the web?

Hosting on the web is a hit or miss, you will find a wide range of providers, from dirt cheap hosting companies that will lump you in with hundreds of other databases, to premier firms that will rent you a server all for your self. Many traps to avoid If you're not careful you may end up with a host [...]

2015-07-03T19:30:03-05:00December 27th, 2011|

Our favorite online small business tools

Our Access/SQL Server/SharePoint practice benefits from great tools on the web, some free and some not, and I'd like to share our experiences with you. LogMeIn.com (Free) and LogMeIn Ignition (Subscription) for Windows We usually use the Remote Desktop Connection when working with our client's syste [...]

2011-12-21T05:01:23-06:00December 21st, 2011|

Microsoft's Official Response to ADO mess…

Those of you caught with the Windows 7 SP1 bug that rendered your development computer useless for Access 2007, (including yours truly), can read up on the official Microsoft response to the issue here: http://blogs.msdn.com/b/psssql/archive/2011/10/03/yes-we-made-a-mistake-and-are-finally-going-to- [...]

2011-12-05T23:10:50-06:00December 5th, 2011|

Using control tip property to display real time information

I was selected to be a guest blogger on the official Microsoft Access blog! You can read the article here: http://blogs.office.com/b/microsoft-access/archive/2011/11/28/display-real-time-information-with-the-controltip-property.aspx Please read and come back here for some final thoughts on the techn [...]

2011-11-29T05:31:22-06:00November 29th, 2011|

More fun with Inner Joins

A while back I wrote about a Inner Join technique using a date range. (You can find that post here.) Today I'm going to take it a step further and discuss using inner joins to another query and conclude with an issue in Access you may shed some light on. Using Queries as Inner Joins For the longes [...]

2021-12-14T09:44:37-06:00November 14th, 2011|

Windows 7 64bit Slow with Access 2007 – Solved!

A while back I talked about a problem one of my clients was having with Windows 7 64 bit and Access 2010/2007. It was terribly slow and unacceptable. You can see the original post here. Solution Found - Turn off the LLMNR Protocol My client waited long and hard to get this resolved, but Microsoft di [...]

2017-02-06T22:01:01-06:00November 2nd, 2011|

More Alter Table SQL Statement Help

Creating a primary key using that is also a auto increment field in code can be challenging. This article will discuss how to do so in two steps.

2011-10-31T09:36:48-05:00October 31st, 2011|

Join me at SQL Saturday #86 Tampa on November 5th

I'll be presenting on using Access with SQL Server as a business intelligence, (BI), tool and will cover the following three areas: Using SQL Server as a dashboard agregator with Access Creating powerful Crosstab queries in Access Using Pivot Table Tools Creating Sub-Totals in both Crosstab and Pivo [...]

2011-10-23T18:57:13-05:00October 23rd, 2011|

SQLOLEDB Going to be retired, long live ODBC! Also, Office SP1 crashes Access!

I use SQLOLEDB a lot in my code, thinking I was bypassing some of the ODBC stack. Now it turns out we can use ODBC after all in our connection strings. Here is the post from Microsoft: http://blogs.technet.com/b/dataplatforminsider/archive/2011/08/29/microsoft-aligning-with-odbc.aspx It's probably g [...]

2011-10-20T08:25:48-05:00October 20th, 2011|

Matching records using a date range

The other day I asked Ben to help me with a thorny problem, I needed to match records in one table with records in another table using a date range. Here's the table I needed to update, called tblWidgets: WidgetID DateProduced WidgetWeekID ------- ------------ ---- 1 1/2/11 2 1/16/11 3 1/31/11 Widge [...]

2021-03-18T07:36:48-05:00October 10th, 2011|

Follow Steve's footsteps into the future…

He's gone. And we are all fortunate to have had him with us, just as we had Einstein, Edison, Pasteur, and many others. Men of impact, men who expanded their world to touch the next one in the future and bring it back. Steve had taken calligraphy classes and had wanted the same effect on the Mac, wh [...]

2011-10-07T03:14:29-05:00October 7th, 2011|
Go to Top