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