Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 97 Linking tables

Status
Not open for further replies.
NJLDoc

NJLDoc

Programmer
Jan 25, 2002
93
What has to be changed in order to update programatically a linked table. The following code works fine for a non password database but some tables are linked in a password protected database and passing in the password has me stumped.
If tdfLink.Connect <> &quot;;DATABASE=&quot; & dbPath Then
tdfLink.Connect = &quot;;DATABASE=&quot; & dbPath
tdfLink.RefreshLink
End If
 
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
611
mintjulep
M
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
789
hermanlaksko
hermanlaksko
Moss100
  • Locked
  • Question
Updating Outlook Contacts from Access
Replies
0
Views
300
Moss100
Moss100
DBDivaAuto
  • Locked
  • Question
Breaking the VBA Password in Access
Replies
3
Views
352
Andrzejek
Andrzejek
Amy_M
  • Locked
  • Question
Automating Tables from VBA to AutoCAD
Replies
3
Views
229
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top