Re: Unstable links to MySQL database from Access
Well... I just figured out a way to get around it. You can run this code on startup to refresh the links to your tables. However, this is quite slow for large volumes of data, and I sure hope there is a better way of fixing this problem.
'Refresh Table Links
Dim tbl As TableDef
For Each tbl In CurrentDb.TableDefs
If Len(tbl.SourceTableName) > 0 Then
tbl.RefreshLink
End If
Next tbl
This refreshes the links for every linked table in the current database. If all of your tables are linked, and there are no local tables, then I guess that if statement would be unnecessary.
Subject
Views
Written By
Posted
3715
January 06, 2005 02:33PM
2233
January 14, 2005 01:55PM
Re: Unstable links to MySQL database from Access
2231
January 15, 2005 01:11PM
2132
January 17, 2005 07:41AM
2384
January 17, 2005 08:14AM
2205
January 19, 2005 07:33AM
2140
January 19, 2005 09:22AM
2063
January 19, 2005 10:07AM
2072
May 12, 2005 04:51PM
2539
May 13, 2005 02:57PM
2327
June 10, 2005 10:00AM
2178
June 10, 2005 02:50PM
2237
July 11, 2005 11:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.