> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Throwback Thursday: August 29, 2024
- URL: https://nolongerset.com/throwback-thursday-2024-08-29/
- Published: 2024-08-29T12:04:26.000Z
- Updated: 2026-05-08T12:41:45.000Z
- Description: Today's edition of Throwback Thursday is all about how Access talks to SQL Server. It's much chattier than you realize.
- Author: Mike Wolfe
- Tags: Throwback Thursday, #Import 2026-05-20 02:59

*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 ServerYou won’t believe how Access and SQL Server actually talk to each other. You’re going to need to see this for yourself.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/01/telephone-450639_1920.jpg)](https://nolongerset.com/playing-telephone-with-sql-server/)

[How Access Reads Data From SQL ServerHow 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.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2022/02/data-2899900_1920.jpg)](https://nolongerset.com/how-access-reads-data-from-sql-server/)

[Peeking Under the HoodDon’t let these gotchas trip you up when using SQL Server as a backend for Microsoft Access.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2020/10/old-2416221_1920.jpg)](https://nolongerset.com/peeking-under-the-hood/)

## Wisdom from Around the Web

[Optimizing Microsoft Office Access Applications Linked to SQL Server![](https://learn.microsoft.com/favicon.ico)Microsoft LearnArchiveddocs![](https://learn.microsoft.com/en-us/media/open-graph-image.png)](https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/bb188204%28v=sql.90%29)

[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![](https://cdn.sstatic.net/Sites/dba/Img/apple-touch-icon.png?v=cdcd5ff7b29e)Database Administrators Stack Exchangemwolfe02![](https://cdn.sstatic.net/Sites/dba/Img/apple-touch-icon@2.png?v=246e2cb2439c)](https://dba.stackexchange.com/q/105596/6390)

## Developer Humor

[![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2024/08/harold-wrong-database-selected-8388409-rows-affected.jpg)](https://starecat.com/harold-wrong-database-selected-8388409-rows-affected/)

*Cover image generated by Ideogram*