Changing the datasource on existing reports

[GBall]

Ho,
I've inherited an old system using Access 2.0 / VB5, which I'm trying to bring up to Access 2000 using VB6.
I've installed the report designer from the VB6 CD and installed the Access2000 drivers from Crystal Decisions, but I still get the "unrecognized database format" error.
I have created an ODBC dsn for my A2K database and can create a new report with no problem.
So,is there something I'm not doing right with the drivers to get the exising reports to work ?
Or is there a way that I can change the datasource for the existing reports to point to the DSN that I know will work (I can't seem to get away from the .mdb file at the moment)?
This is CRW 4.6 I'm using here.
TIA
Regards,
Graham

 

[WillRiley]

Graham,
Not sure if this will help, but on Crystal 7, you can use the 'set location' function from the 'database' menu option.
You can either log on to a different server or choose new data sources by selecting the 'log on server' button.
Once you have done this, select 'done' and you should get a message asking you if you'd like to have you reports re-mapped to the new source tables. If your table/field names are the same, Crystal can do this bit automatically. If not, you may have to map old fields to new one using the wizard which appears..
Like I said - we changed servers today so I been doing it for all our reports, however I don't know if your circumstances are the same (or if earlier versions of crystal have this function)
Will.

 

[GBall]

Thanks, but no.
I only get the option to select a .mdb file from there B-(
Regards,
Graham

 

[bbyrd36]

Try going to Database, Convert Database. You should be able to point the tables to your new ODBC connection and then check the fields.

 

[GBall]

I don't appear to have convert database in 4.6
Regards,
Graham