Linked Tables and updating

[emeryp]

Hi Everyone,
Has anyone automatically updated their linked tables? I have used the linked table manager to perform the update, but am looking for a way to perform this in my code in VB 6.0. Looking around, it looks like the DoCmd may help? Any ideas would be helpful.
Emery

 

[cmmrfrds]

Create a Link Example.

Function ADOCreateAttachedODBCTable()

Dim cat As New ADOX.Catalog
Dim tbl As New ADOX.Table

' Open the catalog
cat.ActiveConnection = CurrentProject.Connection

' Set the name and target catalog for the table
tbl.Name = "Titles"
Set tbl.ParentCatalog = cat

' Set the properties to create the link
tbl.Properties("Jet OLEDB:Create Link&quot = True
tbl.Properties("Jet OLEDB:Link Provider String&quot = _
"ODBC;DSN=ADOPubs;UID=sa;PWD=;"
tbl.Properties("Jet OLEDB:Remote Table Name&quot = "titles"

' Append the table to the collection
cat.Tables.Append tbl

Set cat = Nothing

End Function

 

[emeryp]

Thank you cmmrfrds,
Now am I correct in assuming that the tables will automatically update when I issue the refresh command?
emery