SQL Server with Access Articles, tips and tricks
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.
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.
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 [...]
When querying SQL Server date fields in Access, you may need to use the time specification to get all of the records in your date range.
Over the weekend I had the great pleasure to participate in SQL Saturday #73 in Orange County California, my two sessions were well attended and I had a lot of interest from SQL Server professionals on how to maximize performance between Access and SQL. Why I won't post my presentation I received nu [...]
All the information you need in creating connection strings for Microsoft Access and SQL Server.
Access with SQL Server is a great combo, but you do need to be aware of certain issues and optimize the relationship to make it a rewarding experience for your users. This article will talk about the steps you need to take and how to avoid some pitfalls.
Using ADODB recordsets and command objects in your Access code can be daunting, but you can greatly simplify it by using the code in this article.
The other day I was trying to link two tables using memo fields, (don't ask why), using an Access query, that's when I realized it can't be done in Access. Since the data was hosted in a SQL Database, I tried the same thing in a SQL query using SQL Server Management Studio, (SSMS), and viola, no p [...]