Crystal 9 security issue

[Pasvorto]

I my continuing saga to upgrade my VB app from CR8.5 to CR9.0.

In the Project refernces area, I removed Report Viewer, Report Export, 8.5 ActiveX Design and Run Time, 8.5 Library, and 8.5 ActiveX Designer Run Time stuff and replaced them with their 9.0 equivalents.

When I run a report now, I get the following error:

An error occurred: [-2147189176] logon failed
Details: DAO error code 0xbd7
Source: DAO workspace
Description: Not a valid password Source: Crystal Reports Active X Designer

I changed no code from 8.5 to 9.0. This is the code:

Set Report = crxApplication.OpenReport("C:\JobsUnder1K.rpt", 1)
For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.SetLogOnInfo "", "", "", "password"
crxDatabaseTable.LOCATION = "C:\Techni.mdb"
Next crxDatabaseTable
Report.SelectPrinter glbPrinterDriver, glbPrinterName, glbPrinterPort
If glbPrinterDestination = 0 Then
glbReportForm = "frmProduction"
CRViewer.Show vbModal
Else
Report.PrintOut False
End If

Any ideas?

[Pasvorto]

I tried changing the code to this:

For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.ConnectionProperties("Database Name") = "C:\Techni.mdb"
crxDatabaseTable.ConnectionProperties("Password") = "password"
Next crxDatabaseTable

Now, the error message is:

An error has occurred: [-2147417848] Method 'Value of object 'IConnectionProperty' failed - Source: Techni

(Techni is the system)