Database connection

[Aakash]

hi,

How can i change the database path after completing the form.
When i made the new form and used the data connection wizard , i specified a
database located in mydocuments folder and the xsn file was saved in desktop.
Now where ever i copy the file , i am forced to put the file in desktop and
database in mydocuments.

 

[Shanthi]

Hi Aakash,
The dataconnection is specified in manifest.xsf file. One way to change this
is, open manifest.xsf file in text editor and Go to the location of your
dataconnection and change the location of the database in the connection
string to the new one.
For Ex:
If your Old Connection points to
Data Source=C:\abc\db1.mdb
Than chage this to Data Source=C:\def\db1.mdb.