Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

URGENT - setting Crystal Report (.rpt) Database Location

URGENT - setting Crystal Report (.rpt) Database Location

URGENT - setting Crystal Report (.rpt) Database Location

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.


RE: URGENT - setting Crystal Report (.rpt) Database Location

Are you connecting to the database natively or by ODBC?
If it is ODBC then you will need to point the ODBC datasource to the correct database. Then go into Crystal and set the location to the new database location. If you strip each of the tablenames in Crystal back to just the table name (ie - remove the database name and .mdb from the string) then each time the report is run using ODBC, as long as the ODBC datasource name is exactly the same as the one that you used to set the location in crystal, you can access any database with the same table names.
I have not developed reports which connect natively to the datbase, but it is my understanding that the reports must be in the same directory as the database.
Please let me know if you need further help (or a more detailed explaination!)

RE: URGENT - setting Crystal Report (.rpt) Database Location

Thanks for your reply Justine.

I am connecting to the database natively, I think (!). No password is required to access the database on the file server.

A more detailed explanation would be appreciated.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close