Crystal report

[Guest_imported]

I have developed an VB-MSAccess application with crystal reports which uses the datafile to design the crystal report.

Now i want to port the application to MSSQL server and make the application run for both MSSQl and MSAccess.How can i make the same report work for 2 databases...which connection should i use?

Pls....help...
thanks in advance
saajid

 

[vganeshbabu]

In this Situation from your VB code u can change the database location from MS-Access to MS-SQL server. No need to add another connection

 

[shaikhintekhab]

Use the DSN.
You can change the DSN at runtime.

 

[Guest_imported]

How can i create a DSN dynamically?