> ## 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.

# Field Comments on Linked Tables
- URL: https://nolongerset.com/field-comments-on-linked-tables/
- Published: 2021-06-02T19:05:54.000Z
- Updated: 2026-05-08T13:04:24.000Z
- Description: In this 6-part series, I cover everything you need to know about field descriptions for linked tables with Access and SQL Server back-end databases.
- Author: Mike Wolfe
- Tags: Basic, SQL Server, #Import 2026-05-20 02:59

Editing field (a.k.a., column) descriptions (a.k.a., comments) on local Access tables is straightforward. Open the table in Design View, then enter the description in the Description column to the right of the field name:

![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/06/image-4.png)

Of course, if you are following Microsoft Access best practices, then you will have [split your database application](http://allenbrowne.com/ser-01.html) between a front-end GUI and a back-end database. And that means you have *linked tables* in your front-end. 

Managing field descriptions on linked tables presents a new set of challenges. If you're not careful, you can document your entire database schema in your front-end application only to lose that documentation when you relink your tables.

And what if the back-end tables are in SQL Server? That presents a different set of challenges.

Never fear! In this six-part series of articles, I cover all those issues. I also wrote several procedures that you can use to take the drudgery out of synchronizing field comments between SQL Server and your front-end linked tables.

Enjoy!

### Part 1

This article discusses the considerations that are unique to dealing with linked tables where the source tables are in separate Microsoft Access files (as opposed to SQL Server or another RDBMS).

[Field Comments on Linked Access Tables in MS AccessIn part 1 of this series on field comments, we discuss maintaining column descriptions on tables linked to MS Access back-end files.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/05/Field-Comments-Linked-Access-Tables-1-.jpg)](https://nolongerset.com/field-comments-on-linked-access-tables/)

### Part 2

This article describes the GUI and T-SQL techniques you can use to update field descriptions in SQL Server. It also discusses the permissions required to do so.

[Setting SQL Server Field DescriptionsThere are two basic ways to set field descriptions in SQL Server: via SSMS and T-SQL. Let’s explore both.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/05/SQL-Server-Field-Descriptions.jpg)](https://nolongerset.com/setting-sql-server-field-descriptions/)

### Part 3

This article includes the `UpdateColDescDDL()` function that generates a T-SQL string to create or update column descriptions in SQL Server.

[Use VBA to Generate T-SQL to UPSERT a Column DescriptionLet’s combine the stored procedures to Update and Insert SQL Server field comments into a single, all-encompassing solution.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/05/Upserting-SQL-Server-Field-Descriptions-2-.jpg)](https://nolongerset.com/upsert-a-column-description-in-sql-server/)

### Part 4

This article includes the `PullColDescs()` function that extracts column descriptions from a SQL Server source table and sets those descriptions to the local front-end TableDef links.

[Set Field Descriptions on Linked SQL Server tablesWhat good are field descriptions in SQL Server if you don’t see them in your Access front-end? Here’s some code to bring those comments forward into Access.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/05/Setting-Field-Descriptions-on-Linked-Tables-1-.jpg)](https://nolongerset.com/setting-field-descriptions-on-linked-sql-server-tables/)

### Part 5

This article includes the `ExtractFieldComments()` function that returns a dictionary of field names and comments from a TableDef object.

[Easy Access to Field DescriptionsThe ExtractFieldComments() function returns a dictionary of field names and their descriptions from a TableDef object.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/05/Retrieving-Field-Descriptions-1-.jpg)](https://nolongerset.com/easy-access-to-field-descriptions/)

### Part 6

This article includes the `PushColDescs()` function that creates or updates column descriptions on a source SQL Server table using the column descriptions from the front-end table link.

[Pushing Field Comments to SQL ServerA VBA routine that takes field comments from a front-end linked table and pushes them to the corresponding back-end table in SQL Server.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/06/Pushing-Field-Descriptions.jpg)](https://nolongerset.com/pushing-field-comments-to-sql-server/)

*Image by [Kohji Asakawa](https://pixabay.com/users/deltaworks-37465/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=250016) from [Pixabay](https://pixabay.com/?utm%5Fsource=link-attribution&utm%5Fmedium=referral&utm%5Fcampaign=image&utm%5Fcontent=250016)*