Crystal Report & Visual Basic & Database password protected

[Guest_imported]

I'm getting a run-time error 20534 when I try to access
a report in the application. The database is password protected.

The code I'm using is:

rptOpenJobs.ReportFileName = App.Path & "\openjobs.rpt"
rptOpenJobs.Password = "rollab123"
rptOpenJobs.SelectionFormula = "{Jobs.Status}=" & 1
rptOpenJobs.Action = 1

Some suggestion?

 

[dcm]

mondur: You will need to ensure that you have logged onto the data source by for example using SetLogonInfo method to pass password to database David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner

 

[Guest_imported]

I am using Crystal version 4, with Visual Basic 6, the database is with Access 2000, when I trying open the report a message appears in the screen (in the program), "Put the Access password", the data base is not protected, I think that the problem is with the Crystal version.

Could you help me with this problem.
Thank you
Miguel Moreno

 

[emcevoy]

Hello

What you will need to do is to download the Access 2000 driver for crystal reports. Crystal reports 4 was before Access 2000 and the driver has changed, here is the link, it should fix things for you.

http://support.crystaldecisions.net/communityCS/FilesAndUpdates/access2000drivers.zip.asp

Hope this helps. E. McEvoy
Crystal Reports Consultant

http://www.pacificridgesolutions.com