Click to See Complete Forum and Search --> : Using different database names at run time with VB6,SQL & Crytal Reports


jshailes
November 29th, 2006, 05:51 AM
Hi,

I have some reports designed using Crytsal Reports 9.

They work fine with the SQL database they were created with.

Now I need to be able to use different SQL databases (same structure/tables etc).

If I disconnect the database I was using and change all references in code to the new database name and run the report I get the Crystal Reports error message:

The table " could not be found

Any ideas would be greatly appreciated!

JShailes.