Throwback Thursday: August 29, 2024
Today's edition of Throwback Thursday is all about how Access talks to SQL Server. It's much chattier than you realize.
With over a million words scattered across more than 1,300 articles on this blog, you've probably missed a few things here.
That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.
Highlights from NoLongerSet.com
Playing Telephone with SQL Server
You won’t believe how Access and SQL Server actually talk to each other. You’re going to need to see this for yourself.
Mike Wolfe
How Access Reads Data From SQL Server
How does Microsoft Access pull data from SQL Server? You’ll be amazed when we pull back the curtain to expose how Access interacts with SQL Server.
Mike Wolfe
Peeking Under the Hood
Don’t let these gotchas trip you up when using SQL Server as a backend for Microsoft Access.
Mike Wolfe
Wisdom from Around the Web
Optimizing Microsoft Office Access Applications Linked to SQL Server
Any reason not to add ‘rowversion’ column?
The TechNet article, “Optimizing Microsoft Office Access Applications Linked to SQL Server”, recommends adding a rowversion column to SQL Server tables linked from MS Access. From the Supporting
mwolfe02
Developer Humor
Cover image generated by Ideogram
