Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Crystal Reports ActiveX Control

Posted on 1999-07-20
Medium Priority
Last Modified: 2006-11-17
I am running VB6.0 and the latest Crystal Reports ActiveX control for VB5.0/6.0 on a Win98 machine.

I have an Access Database for the datasource and a table in the designer is made up of a query.  However, when the database changes and I have to "Verify" the database to make it work correctly, I have to move my database to the location that the designer points to.  How do I change the file that the designer points to?

So, my datasource is "bound" to: "C:\MyFolder\MyDatabase.mdb" but I want it "bound" to: "C:\MyOtherFolder\MyDatabase.mdb"

Any idea how?
Question by:Egore
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Author Comment

ID: 1526330
Do I have to delete the datasource, create a new one datasource and then link all of the controls on the ActiveX control to the new datasource, or is there an easier way?

Expert Comment

ID: 1526331
can'r you just alter the dsn?

Accepted Solution

peterdc earned 450 total points
ID: 1526332
No, this should be quite straightforward - I've even managed it myself.

Use the menu options  Database | Set Location.   Select the main (top) table and 'select location' - point to the access database and table you want. You may get asked to propagate all changes across the database. This will change the location of all tables to be the same (if you have more than one and they exist in the new database).

Expert Comment

ID: 1526333
If you are using their ActiveX (where you actually have a small hidden icon on your form and you set the Action = 1), you can create a 'bound report' that will look at a data control on your form. Then, you can change the database, refresh, even query the database to return only the specific records you need -- All from VB code. Let me know if that sounds like what you want to do. I'll post more info.

PS -- If you are using this (old) control, check out the Seagate website. They have a new ActiveX Designer that actually integrates with the VB IDE. It builds reports directly into your project. It's a little harder to use, but it sure gives you a lot more control over the data. (And best of all, it's completely FREE to users of the old control -- at least it was two months ago when I grabbed it.)

Author Comment

ID: 1526334
Thanks!  I just had to make a minor adjustment to what you said and it works like a charm!

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question