Advanced Search

Return to Snippet

Revision: 47854
at June 17, 2011 14:51 by jkupko
Updated Code 
Dim tDef As TableDef
For Each tDef In CurrentDb.TableDefs
	 If tDef.Connect <> "" Then
		 tDef.Connect = connectionString
	 	 tDef.RefreshLink
	 End If
Next tDef

Revision: 47853
at June 17, 2011 14:24 by jkupko
Initial Code 
Dim tDef As TableDef
For Each tDef In CurrentDb.TableDefs
	 If tDef.Connect &lt;&gt; &quot;&quot; Then
		 tDef.Connect = connectionString
	 	 tDef.RefreshLink
	 End If
Next tDef
Initial URL 
http://blog.loxotech.com/?p=67
Initial Description 









Initial Title





Updating Linked Tables in Access 2007 via VBA









Initial Tags














Initial Language





VB.NET