advanced code snippet search

Posted By

jkupko on 06/17/11


Tagged

vb


Versions (?)

Updating Linked Tables in Access 2007 via VBA: 4

 / Published in: VB.NET
 

URL: http://blog.loxotech.com/?p=67

Expand | Embed | Plain Text 
  1. Dim externalDB as Database
  2. Dim tDef As TableDef
  3. Set externalDB = OpenDatabase("C:\path\to\your\database.accdb")
  4. For Each tDef In externalDB.TableDefs
  5. 	 If tDef.Connect <> "" Then
  6. 	 	 tDef.Connect = connectionString
  7.                  tDef.RefreshLink
  8. 	 End If
  9. Next tDef
  10. externalDB.Close

Report this snippet  

You need to login to post a comment.