TransferDatabase - With Password

  • Thread starter Thread starter Des Norton
  • Start date Start date
D

Des Norton

Hi NG

Using Access 2000/XP, I need to link a large number of tables from an
external Access 2000/XP DB. The external DB is password protected. The
code below works great, however, it requests the password for every table
(±200 tables).

Is there a method to supply the password programmatically, or even only
request it once?


sDBName = "PathToExternalDB"
sSource = "SourceTableName"
sDest = "DestTableName"

DoCmd.TransferDatabase acLink, _
"Microsoft Access", _
sDBName, _
acTable, _
sSource, _
sDest, _
False, _
True

Regards
Des Norton
 
Back
Top