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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
SQL Server Stored Procedures are a great way to leverage SQL Server with your Access database. This post will explain how to use Stored Procedures using Pass Through Queries.
Learn to use temp tables in your Access code.
Article describes how to import Outlook emails into Microsoft Access using code.
