Reports using a Secured Access Database (.MDW) 1

[BigSteve]

For a simple application that I have written in VB6, I need to generate a couple of reports. The database is an Access 97 database and is secured by creating a MDW file with Wrkgadm.exe.
When I run the program it creates a workspace and I enter a username and password which if correct lets me enter into the system. When I click to generate a report, the same username and password are passed to the Crystal Control using :

crystl1.Username = "sdfgfsf"
crystl1.Password = "sdfgsf"

This works fine on my own machine which has Crystal Reports 7 installed but not on some of the other machines. I have created an InstallShield project which installs all the files required according to the runtime help file that comes with Crystal Reports.

The strange thing is that I have installed the system on a machine that was only built recently and the report functionality of the system works fine. Crystal Reports is NOT on the machine. Maybe it is something to do with the version of DAO on the machine??

I did have to run SysDB32.exe on my own machine before I could create the report. SysDB32 found the MDW file that I created but didn't really tell me anything else.

Any help on connecting to an Secured Access database to generate reports with Crystal Reports 7 would be much appreciated.

Steve

 

[albanian]

Hi
What I suggest you to do is to try to build installation disks for the report you have used separately from the installations disks that you use for your application.(If you have more than one report just build the installation disks for one report).The installation disks can be made in the menu Report/Report Distribution Expert of Seagate CRW 7.0
This utility is better than Installshield as it knows perfectly which drivers should take.
Please tell me if it works.
Regards