Updating Linked Tables

[emeryp]

Hi Everyone,
Does anyone know how to automatically update linked tables from VB 6.0? I have manually used the linked table manager but would like to do it within an application.
Emery

 

[CCLINT]

Here is the MS Kb URL to relink via ADO. If you need DAO then let me know.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240222

 

[emeryp]

Hello CClint,
My tables are already linked in Access and I use the object code for the ActiveX component rather than building it from scratch. For instance:

If (OldVar <> Environment) Then
If Not (Environment = &quot;Search&quot Then
If Not (Environment = &quot;SpecTbl&quot Then
StrSQL = &quot;Q_Emed_Docs&quot;
Else
StrSQL = &quot;Q_Dept_lkup&quot;
End If
FrmDocTbl.AdoDocTbl.RecordSource = StrSQL
FrmDocTbl.AdoDocTbl.Refresh
End If
End If

Knowing this, how can I update the linked tables in Access?

 

[CCLINT]

Read the code carefully under the link I posted. There are two sections...