Crystal datasource changing from Access to SQL and vice versa

[tabilda]

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 ODBC 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...

Tabilda

 

[vidru]

Have a look at my FAQ on changing data sources at runtime: faq768-5374. If you happen to be using CR 9 or higher, make sure you read the addendum.

-dave