[RESOLVED] [2005] How to Avoid Access Database password at runtime ?

Hi guys,

I have created report and making report dynamically using SelectionFormula.

However, I have to give password at runtime all the time.

Can anyone tell me, How to cope up with ?

what type of report is it? Crystal Reports? Access Report? without knowing this it is hard to give you an answer other than you would need to pass the login information to your report from your application.

Sounds like a Crystal Report. There is the login credentials when you connect via an ado connection. plus there are .SetLogOnInfo methods for authentication too.

VB Code:

Report.Database.Tables(1).SetLogOnInfo sServer, sDatabase, sUserName, sUserPwd

thank you very much. I have also find another way to do so
CrystalReportViewer1.LogOnInfo.Item(0).ConnectionInfo.Password = "xyz"