If I create a report "Report1.rpt" whose source is a query in an access database then what happens if that database is moved away from the "c:" to a server on a LAN.

My crystalreportviewer on my form will find the report because I installed the project in the same directory but the report itself will not find the query or the database.

What do you developers do to overcome this?
What are the different approaches you can take?

I would love any feedback any of you lot can give me as this seems to be a problem I am certain many of you must have encountered.