Updating Linked Tables in Access 2007 via VBA


/ Published in: VB.NET
Save to your folder(s)



Copy this code and paste it in your HTML
  1. Dim tDef As TableDef
  2. For Each tDef In CurrentDb.TableDefs
  3. If tDef.Connect <> "" Then
  4. tDef.Connect = connectionString
  5. tDef.RefreshLink
  6. End If
  7. Next tDef

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.