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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
Use Rollback with SQL Server scripts to undo changes to your data.
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.
Use self-healing objects to avoid problems with objects not being initialized when running your code.
Learn to use temp tables in your Access code.