If the data is located in the same directory as your EXE file, then you can remove the path from connection string leaving only the database name. In that case the application will look for your database in the current directory.
If you need to have data in separate directory, it should still be easy to manipulate the connection string, provided that these two directories are related. For instance: const cs: String = 'Provider=Microsoft.Jet.OLEDB.4.0;'+ 'Jet OLEDB:Engine Type=5;'+ 'Data Source='; implementation ADOConnection1.ConnectionString := cs+'..\Data\MyDataBase.mdb'; Anu Rang <[EMAIL PROTECTED]> wrote: Hi, Having built my application using a local Access database, I was trying to deploy my application using Installshield express. The thing about deployment on target computer is that normally where the application is installed is decided by the user. Ofcourse it is possible to enforce a particular directory path for installation. Still it is tricky to get a relative path mapped in the ADOConnection object. I just used use connection string and built it using the ADOConnection wizard. If anyone has more info or knowledge I would really appreciate it since this path to the .mdb file really has to be relative and not hard coded. Anu Rang, TotallyFreeEnergy http://totallyfreeenergy.freehoxt.com --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. [Non-text portions of this message have been removed]
