SQL Server - Linked Tables: Add discription to field names in development mode.
In MS Access its easy to add descriptions to fields in table editor. These descriptions are neither taken over when using ssma nor are they brought back to Access when already existing in sql server.
I've written a vba-script that creates an T_SQL script to create all field descriptions of a table. But even if descriptions exists they are not reshown in the linked table.
Thanks for posting.
We are designing on a new Linked Table Manager dialog, incorporating suggestions and requests made in UserVoice and other forums.
The Access Team