hi,

Make sure your sub report not using other database, if sub report using other database and set password, use the following code.

crCommon.LogonInfo(0) = "dsn=;uid=;pwd=Good1;dsq="
crCommon.DataFiles(0) = "C:\db1.mdb"
crCommon.LogonInfo(1) = "dsn=;uid=;pwd=Good2;dsq="
crCommon.DataFiles(1) = "C:\db2.mdb"

yours,
Babu

MailID: k_babs@hotmail.com