Is it possible to addd somwhere in the syntax of the method
TRANSFERTDATABAS the password of the source databse.
Here's an example from the Access Help:
DoCmd.TransferDatabase acLink, "ODBC", _
"ODBC;DSN=DataSource1;UID=User2;PWD=www;LANGUAGE=us_english;" _
& "DATABASE=pubs", acTable, "Authors", "dboAuthors"
You could try this with an Access DB, maybe like this:
DoCmd.TransferDatabase acLink, "Microsoft Access", _
"UID=User2;PWD=www;" _
& "DATABASE=C:\MyPath\MyDB.mdb", acTable, "Authors", "dboAuthors"
This would assume, both databases use the same workgroup information
file.
See Help item TransferDatabase-method for details.
Best regards
Emilia
Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de