Learn the safe way to issue action queries in SSMS
Use Rollback with SQL Server scripts to undo changes to your data.
Presenting at SQL Saturday #79 – Free event!
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 Procedure Guide for Microsoft Access – Part 1
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.
Self-healing Objects
Use self-healing objects to avoid problems with objects not being initialized when running your code.
Use temp tables in your code for quick and easy analysis
Learn to use temp tables in your Access code.
Dynamically sorting forms and reports
Learn how to order forms and reports dynamically using the open event.
Importing Outlook emails into Access
Article describes how to import Outlook emails into Microsoft Access using code.
SharePoint Lists and Microsoft Access in depth
Article will describe how to use SharePoint lists in depth with Microsoft Access.
SharePoint and Access: How do they fit together?
Note: This is the first part of a three part series, you can find the second part here and the third part here. Hello, Access with SQL Server blog readers! This is my first post since joining the firm and I look forward to many more! Both Juan and I will be blogging here about Access, SQL Server and [...]
Winner Announced: Amazon gift card
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 [...]
Use Batch Transactions with SQL Server to Guarantee Results
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 [...]