Creating a unique index for linked table 1

[petecass]

Hi,
Try with another question. When i refresh a link via code the unique index is deleted. Can anyone show me how to recreate the index on a linked table preferably with ado.

cheers

 

[MarkSweetland]

Private Sub NdxUsers()
    
    Dim strIndexSQL As String
    Dim cmd As New ADODB.Command
    strIndexSQL = "create unique index <indexObjectName> on LinkedTblName(UniqueColumnName)"
    With cmd
        .ActiveConnection = [Your Connection Info Here]
        .CommandText = strIndexSQL
        .Execute
    End With
    Set cmd = Nothing    
End Sub

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach