i dont know is there any direct way to do it. but i have done it this way

1. Say File>Extract From Files
2. Goto manifest.xsf file at the extracted location.
3. Find the connection string there and replace it with whatever you want.
4. open xsf file and republish as xsn

Hope this helps!!
Ural

Aakash,

Here is one way to do this:
- extract form files (Open the form in design mode -> File -> Extract
Form Files)
- open manifest.xsf file from the location where you extracted the
files. Use notepad to edit this file.
- inside the manifest.xsf, there is a section that looks like this:
    <xsf:adoAdapter connectionString="... ">
Modify the path that is specified in the connectionString to point to
the new location.
- save the manifest.xsf and close notepad
- right-click on manifest.xsf and select "design". The form will open in
InfoPath Design Mode.
- Save the form. It will be saved as a single file (.xsn).

Good luck!
Alex @ Microsoft

-----Original Message-----
From: Aakash [mailto:aakashmunjal@gmail.com]
Posted At: Tuesday, May 03, 2005 6:33 AM
Posted To: microsoft.public.infopath
Conversation: Changing the datasource
Subject: Changing the datasource

hey,

Once I specify the database location in the datasource connectivity
wizard
for a new form.How can i modify the path if i would like to move the
database
to some other location?