Application Link to Data file

I am using data environment & adodc for data accessing

Data environment & ADODC

I am given the link with the path & file name in the properties (right click menu ) of the data environment. Here it ask for the data base path and name in

data link properties ->connection

After installation of the software in the other machine using packing & development setup. While running of the package it ask for the same path for the database which was given during the programming time, it is not taking the application path where the database file (MS-Access) was installed. For this I have to manually create the same path and put the database there. Then the package work.

What is the solution so that the application automatically find the application path not the path mentioned in the forms data file link to ado or Data environment.

Rahul 2K india :confused:

use app.path in your connection string.

Else use a find file function when the prgram starts.

Or just make the user find the path to it when they find it save the path!