MySQL Forums
Forum List  »  Microsoft Access

Re: Unstable links to MySQL database from Access
Posted by: Brett Bavar
Date: January 15, 2005 01:11PM

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.

Options: ReplyQuote




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.