I'm using Crystal Reports 7 Pro as the Reporting Tool for my VFP6 Application.

I have a Report setup using a Crystal Data Dictionary, which has access to my DBC and Tables via an ODBC Connection.

Obviously when I distribute this application I don't want to make the user store their Data in the exact same place I have, so I am changing the location of the Data Source at Runtime. To do this I am modifying the ODBC DSN to point to the new DBC and I also enumerate all tables being used in the Report to make sure their "LogOnInfo" is pointing to the new DBC location.

After making these changes I even run the Database Objects "Verify" Method to make sure the Report is happy with where it needs to get its data and it is.

Now the problem.. When I eventually get down to the "Preview" method, it generates the following Error:

"OLE lDispatch exception code 20533 from CPEAUT32: Unable to open Database.."

I don't understand why I'm getting this message, everything else upto this point is fine. Also, this does work when I'm running from my Development PC.

I'm sure it's not a problem with Data Location as I've even gone so far as to recreate the same Data Location used by my development PC and I still get the error.

I have installed all the neccessary runtime files for Crystal on the client PC using their Help as a reference and I've also registered the CPEAUT32.DLL

Is there something else I'm missing?

Thanks,

- Aaron.