Help! Automatically Updating Linked tables

[proflola]

Hi All you Smart Folks!

I have an Access 2003 database that is tracking Claims. It's based on linked tables that reside in another database. How can I automatically update the linked tables without having to manually do so in Linked Table Manager?

Thanks for any assistance you can render...

--Sandy

 

[cdck]

I find that in the databases that I use with the same parameters, I do not have to update the linked tables unless the structure of the table changes. If records in the tables change, are added, or are deleted, those changes show automatically.

Is this your experience? Are you having issues with structure changes not showing or data changes not showing?

Cheryl dc Kern

 

[lameid]

Sandy,

cdck is right. But do you mean your backend is moving or you want to work with one set of data for a while and then change?

If so, please explain.

 

[rheitzman]

Snippet untested

    With db.TableDefs
    Set cTables = New Collection
    For Each tdf In db.TableDefs
        If Len(tdf.Connect) And Not tdf.Name Like "MSys*" Then
            db.TableDefs(CStr(vName)).RefreshLink
        End If
    Next tdf

 

[rheitzman]

replace CStr(vName) with tdf.Name in code above

I made a collection in one spot in my code so I could remove the links - hard to do without a baseline set of table names.

 

[PHV]

Have a look here:

http://www.mvps.org/access/tables/tbl0009.htm

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886