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
3517
January 06, 2005 02:33PM
2132
January 14, 2005 01:55PM
Re: Unstable links to MySQL database from Access
2094
January 15, 2005 01:11PM
2034
January 17, 2005 07:41AM
2289
January 17, 2005 08:14AM
2042
January 19, 2005 07:33AM
2030
January 19, 2005 09:22AM
1980
January 19, 2005 10:07AM
1970
May 12, 2005 04:51PM
2404
May 13, 2005 02:57PM
2159
June 10, 2005 10:00AM
2090
June 10, 2005 02:50PM
2073
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.