How to add / change the value of the Description property for LinkTable in VBA?

Question

I have a LinkTable that points to an existing SQL server table in my Access database. I need to change the value of the Description property for this table.

I tried many ways, but could not do it.

Can anyone help me in this regard?

Answer 1

Some notes.

Dim db As DAO.Database Dim tdf As TableDef Set db = CurrentDb Set tdf = db.TableDefs("Table1") On Error Resume Next tdf.Properties("Description") = "Link" If Err.Number = 3270 Then Set prp = tdf.CreateProperty("Description", _ dbText, "Link") tdf.Properties.Append prp End If