Crystal Report from MDB with password

[sisan]

I know to use VB, Access and Crystal Report such as:

Private Sub Command1_Click()
cr1.DataFiles(0) = [Access/.MDB file]
cr1.ReportFileName = [Cystal report/.RPT file]
cr1.Destination = crptToWindow
cr1.Action = 1
End Sub

But how if the .MDB contains a password?
Urgently need ur help

Regard,
Sigit

 

[sisan]

Anybody please help me?

 

[vidru]

You need to supply the password to the database before you can run the report. I haven't used the OCX in a very long time, but try adding this line:

cr1.Connect = "PWD=YourPassword"

-dave

 

[sisan]

Wow, its so simple. But this is what I need to know, and ..
thanks, Dave