Post Author: svenworm
CA Forum: Data Connectivity and SQL
Hi there,
I am trying to implement some CR Reports into my MS ACCESS 2000 Database which has MDW Systemdatabase. Inside CR XI Developer the Reports are shown and are OK. Integrated into MS ACCESS via the cr report viewer activex control I receive an error when connecting to the database:
Within the "techref.pdf" I found Info about how to connect to a secured MS ACCESS MDB, but there is nothing said about the Systemdatabase. The Parameter is called "system database path", I guess.
Code:
' Create a new instance of the report.
Dim Report As New CrystalReport
Private Sub Form_Load()
' Declare a ConnectionProperty object.
Dim CPProperty As CRAXDRT.ConnectionProperty
' Declare a DatabaseTable object.
Dim DBTable As CRAXDRT.DatabaseTable
' Get the first table in the report.
Set DBTable = Report.Database.Tables(1)
' Set the new database location and the new table name.
DBTable.SetTableLocation "C:\databases\xtreme.mdb",
NewCustomer, ""
' Get the "Database Password" property from the
' ConnectionProperties collection.
Set CPProperty = DBTable.ConnectionProperties("Database
Password")
' Set the database password.
CPProperty.Value = "password"
Any hints ??
Greets Sven