Archive Collection: Field Descriptions

I'm on a short vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy this curated collection of articles. Today's topic: Field Descriptions.

Archive Collection: Field Descriptions

I've been writing a daily article here since September 1, 2020; that's over 1,000 articles.  I haven't missed a day yet, and that includes Christmas and Easter.  Well, I'm taking my first another (short) family vacation.

I'm writing this in the present tense, but I'm writing it for future publication with links to past articles.  Let's hope the time-space continuum holds up.

In any case, as the slacker Firstie says to the Stony Lonesome Gate guard twenty minutes before Taps, let me get to the Point.  I've got a daily publishing streak to keep up.  But I don't want to be writing and publishing articles on vacation.  And I still want to provide you with something of value to read each day.  So I settled on creating a series of curated article lists that I think you'll find beneficial.

I'm hoping at least some of these articles are ones you haven't read before.  And if you're so obsessed with me that you have read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.  


Field Descriptions

Field Comments on Linked Access Tables in MS Access
In part 1 of this series on field comments, we discuss maintaining column descriptions on tables linked to MS Access back-end files.
Setting SQL Server Field Descriptions
There are two basic ways to set field descriptions in SQL Server: via SSMS and T-SQL. Let’s explore both.
Use VBA to Generate T-SQL to UPSERT a Column Description
Let’s combine the stored procedures to Update and Insert SQL Server field comments into a single, all-encompassing solution.
Easy Access to Field Descriptions
The ExtractFieldComments() function returns a dictionary of field names and their descriptions from a TableDef object.
Pushing Field Comments to SQL Server
A VBA routine that takes field comments from a front-end linked table and pushes them to the corresponding back-end table in SQL Server.

All original code samples by Mike Wolfe are licensed under CC BY 4.0