TransferDatabase - With Password

[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