Yearly Archives: 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: 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|

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|

Online Utilities for Access Developers

Frequently, we work remotely on our clients' network, doing development work with one of their workstations and/or servers. As a consequence, it's not always desirable or practical to install our favorite utilities. We therefore make good use of online utilities that can help make development easier [...]

2011-09-29T22:44:48-05:00September 29th, 2011|

Access Services: Bringing your Access database to the web

Note: This is the third part of a three part series, you can find part one here and part two here. Authored by Ben Clothier To continue the series on Access and SharePoint integration (part 1 and part 2), we'll be looking at the latest kid on the SharePoint's block; Access Services. Access Services [...]

2021-03-03T10:40:51-06:00September 19th, 2011|

Stored Procedure Guide for Microsoft Access – Part 3

Authored by Ben Clothier This is a continuation of series Juan started exploring using stored procedures with Access. To see the previous articles, visit part 1 and part 2.  If you have been following the series, Juan already has walked you through how to use a stored procedure on the Access side. W [...]

2021-03-18T07:32:03-05:00August 25th, 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'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|
Go to Top