I’m in the process of Packaging my VB6/ Access 97 database application, which will be installed at my workplace. I’ve created the application on my home PC, with the database and VB application in a folder on my C: drive.
However, to allow multi-user access, I will be installing the VB application on the C: drive of a number of PC’s at my workplace, and the Access database on a departmental network file server G: drive.
I’ve changed the DatabaseName property of all the Data Controls in my VB application to the proposed location of the database (on the G: drive). Also, I’ve changed all the ReportFileName of all the Crystal Reports objects in my VB application to the proposed location of the Crystal Reports .rpt files (on the C: drive).
However, the question is, how do I get the actual Crystal Reports .rpt files to locate the proposed Access database location (i.e. G: drive). I’ve tried the Set Location command in Database/Set Location in Crystal Reports but it doesn’t allow me to set the location of the database to the proposed G: drive location.
Is it simply a case of putting the reports .rpt files in the same location as the Access Database and then setting Database/Set Location to Same As Database, and changing the VB application ReportFileName of all the Crystal Reports objects to the same location?
Thanks in advance.
Jis
However, to allow multi-user access, I will be installing the VB application on the C: drive of a number of PC’s at my workplace, and the Access database on a departmental network file server G: drive.
I’ve changed the DatabaseName property of all the Data Controls in my VB application to the proposed location of the database (on the G: drive). Also, I’ve changed all the ReportFileName of all the Crystal Reports objects in my VB application to the proposed location of the Crystal Reports .rpt files (on the C: drive).
However, the question is, how do I get the actual Crystal Reports .rpt files to locate the proposed Access database location (i.e. G: drive). I’ve tried the Set Location command in Database/Set Location in Crystal Reports but it doesn’t allow me to set the location of the database to the proposed G: drive location.
Is it simply a case of putting the reports .rpt files in the same location as the Access Database and then setting Database/Set Location to Same As Database, and changing the VB application ReportFileName of all the Crystal Reports objects to the same location?
Thanks in advance.
Jis