Dynamically changing of Server Name in Crystal Report

See more:

C#3.5

MS-Access

reporting

Hello All,

My project is in C#.NET with Microsoft Access as its database, with the initial location of database in E:\Project Folder, and the name of my db is Bill.accdb.
I designed a crystal report using Visual Studio, with the same database. And it works fine.

The problem arises when I changed the location of my database, It is showing "Login Failed. Please Try Again Error."

My question is: Is there any reliable way to change the server, and db from code (during runtime) so once we go live with some reports, they will still work on the other server machine with the other db?

I appreciate any help...
God Bless
Shweta Saxena