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.
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 [...]
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 [...]
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 [...]
Recordsets are an essential tool of any Access programmer, there are many types and are used in a wide range of situations, today we're going to talk about form recordsets and provide some examples of their use. What are Form Recordsets? If your form has a data source, either a table or query, it ha [...]
Hello Everyone, Just wanted to let you know I'll be in the San Jose/Aptos California area from May 17th through May 26th. I'm available for any Access/SQL Server user meetings or meetups with other Access enthusiasts to talk about Access and/or Access with SQL Server over coffee. Perhaps you've alwa [...]
