Crystal datasource changing from access to SQL

Hello!

I have a vb6 app that can run on either and Access or a SQL server database depending on which the client required...

I have created one set of crystal reports that I wish to run off both databases - depending on where the ODBC is pointing at. The trouble is that I have to go back into the crystal report and do a 'set location' every time i want the report to swap from access to SQL - even though the PDBC is called the same and the databases are physically identical.

Can i send through a connectionstring at view-time or something? Any ideas?

Sorry if this is confusing... :afrog:

Tabilda