Refresh all values in a linked table

[lss]

I am looking for a simple way to refresh all of the values in a linked table.

If I put the cursur on the table and click the fields the values will change
but I would like this to happen automatically.

 

[Mike Scirocco]

I am looking for a simple way to refresh all of the values in a linked table.

If I put the cursur on the table and click the fields the values will change
but I would like this to happen automatically.

Will RepaintObject work?

Mike

 

[lss]

--no go--

I have tried the two macros below...

Sub AllTables()

DoCmd.RepaintObject acTable, "T4"
DoCmd.RepaintObject acTable, "C5"

End Sub

Sub AllTables()

CurrentDb.TableDefs("T4").RefreshLink
CurrentDb.TableDefs("C4").RefreshLink

End Sub

Any other suggestions?

 

[Mike Scirocco]

--no go--

I have tried the two macros below...

Sub AllTables()

DoCmd.RepaintObject acTable, "T4"
DoCmd.RepaintObject acTable, "C5"

End Sub

Sub AllTables()

CurrentDb.TableDefs("T4").RefreshLink
CurrentDb.TableDefs("C4").RefreshLink

End Sub

Any other suggestions?

Does it need to happen from code?

http://www.techonthenet.com/access/tables/refresh_links.php
http://www.ucisa.ac.uk/help/admin/db_access_table_remoterefresh

Mike

 

[Mike Scirocco]

I am looking for a simple way to refresh all of the values in a linked table.

If I put the cursur on the table and click the fields the values will change
but I would like this to happen automatically.

RefreshLink Method

Updates the connection information for a linked table (Microsoft Jet
workspaces only).

Syntax

tabledef.RefreshLink

The tabledef placeholder specifies the TableDef object representing the
linked table whose connection information you want to update.

Remarks

To change the connection information for a linked table, reset the
Connect property of the corresponding TableDef object and then use the
RefreshLink method to update the information. Using RefreshLink method
doesn't change the linked table's properties and Relation objects.

For this connection information to exist in all collections associated
with the TableDef object that represents the linked table, you must use
the Refresh method on each collection.

 

[lss]

Yes!
I tried this previously and it works great but only for the one instance.
I would like to automate this process.

Do you know what functions control the Linked Table Manager?

Thx..so far, so good.

 

[Mike Scirocco]

Yes!
I tried this previously and it works great but only for the one instance.
I would like to automate this process.

Do you know what functions control the Linked Table Manager?

This page has a download that includes 2 databases, in one of them there
are 2 different methods of updating a linked table:

http://www.databasejournal.com/features/msaccess/article.php/3591276
http://www.databasejournal.com/img/2006/03/ManualTableRelinking.zip

Maybe one of them will be suitable to your needs,
Mike

 

[Mike Scirocco]

Yes!
I tried this previously and it works great but only for the one instance.
I would like to automate this process.

Do you know what functions control the Linked Table Manager?

Thx..so far, so good.

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

 

[Mike Scirocco]

disappointing
http://www.tek-tips.com/viewthread.cfm?qid=1272174&page=10