View Single Post
  #1 (permalink)  
Old May 29th, 2007, 10:59 AM
sajid_rauf sajid_rauf is offline
Registered User
 
Join Date: May 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Crystal Report 9 password protected mdb ACCESS

Hi,

I can access my protected mdb in the CR designer in VB6 via giving it the password when I make the connection via wizard but when I run the software it forgets the password and does not connect to the DB at run time. I am using Crystal Report 9

How can I supply the password in my code?

Code:
dim Report as new myrep 'myrep is the report in the designer

Private Sub Form_Load()
Screen.MousePointer = vbHourglass
CRViewer91.ReportSource = Report
CRViewer91.ViewReport
Screen.MousePointer = vbDefault
End Sub
Hoping to receive an early reply.

Take care, Peace!

Reply With Quote