Skip to Content
0
Former Member
Sep 07, 2007 at 08:03 AM

CR XI: Connect to a MS ACCESS 2K MDB (w/ MDW Systemdatabase)

39 Views

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