VB.Net Crystal Reports Access Password Protected Database

[slink9]

I have an Access database that I have recently had to password protect. I am using CR8.5 to do the reporting and it worked fine until I password protected the database. This is the code that worked.

Dim CR As New ReportDocument
CR.Load(reportPath) ' & ".rpt")
Dim crParameterDiscreteValue As ParameterDiscreteValue
Dim crParameterFieldDefinitions As ParameterFieldDefinitions
Dim crParameterFieldLocation As ParameterFieldDefinition
Dim crParameterValues As ParameterValues
crParameterFieldDefinitions = CR.DataDefinition.ParameterFields
crParameterFieldLocation = crParameterFieldDefinitions.Item("Agency Name")
crParameterValues = crParameterFieldLocation.CurrentValues
crParameterDiscreteValue = New CrystalDecisions.Shared.ParameterDiscreteValue
crParameterDiscreteValue.Value = ReportParamName
crParameterValues.Add(crParameterDiscreteValue)
crParameterFieldLocation.ApplyCurrentValues(crPara meterValues)
crViewer1.ReportSource = CR
crViewer1.Show()
Me.WindowState = FormWindowState.Normal
Me.MaximizeBox = True

What modifications do I need to make to add in the password. I do not have a username on the Access database. Everything that I have seen is pointing toward LOGONINFO and a username seems to be required. This is CR8.5 but I could move up to 10 if necessary. If someone can guide me in either getting 8.5 to accept the pwd or updating to 10 (references, dlls, code) and get the password fed in I would greatly appreciate it..

[kenobewan]

Usually the un & password is fed through the connection string in a config file, which may be encrypted. HTH.

[slink9]

The connection string (UDL) is not encrypted and does have the database location and name but the password is added to it in VB code.