Access password-protected database.

[Flupke]

Hello everyone,

I still have problems to display reports based on password-protected databases.
The database is Access 2003.
Crystal Reports is version 10 and I use the CrystalActiveXReportViewer (crViewer.dll) to display my reports. I am NOT using the Report Designer.
This CrystalActiveXReportViewer is placed on a form in a Visual Basic 6.0 program.

You pointed me to several example-files, but those examples which were given here all use the Report Designer. So far I wrote the following code to display reports for non-password-protected databases. This code works fine.

Dim crxToepassing As New CRAXDRT.Application

With crViewerDienstrooster
.ReportSource = crxToepassing.OpenReport(gsRapportnaam)
.ViewReport
End With

Set crxToepassing = Nothing

Can someone help me to include code to allow password-protected databases or point me unto information to set the database-password using the CrystalActiveXReportViewer in Crystal Reports 10 and not using the Report Designer.

When I look at the examples using the Report Designer, I do not seem able to integrate them with my existing code.

What am I missing?

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel

 

[synapsevampire]

When you say Report Designer, do you mean the Crystal Reports product, or the Report Designer Component (RDC)?

Here's the sample app for user/pw using the RDC:

http://support.businessobjects.com/communityCS/FilesAndUpdates/SCR8_VB_RDC_DBPassword.exe.asp

The RDC is the suggested means for VB code integration.

-k

 

[vidru]

I replied to your other post...

-dave