Maybe I don't understand the question.
If the database will always be at the same relative path to the exe then using extractfilepath(paramstr(0))+'data\mydatabase.mdb' should work eg If the exe is in \\server1\apps\myapp.exe <file:///\\server1\apps\myapp.exe> database will work if its \\server1\apps\data\mydatabase.mdb <file:///\\server1\apps\data\mydatabase.mdb> if exe is in c:\myprograms\thegoodone\myapp.exe database will work if its c:\myprograms\thegoodone\data\mydatabase.mdb I have just tested it and it works. Or do you mean that each user has a local database on their computer, and the exe is stored in the server? The registry would be a good option; or an INI in the server that uses the computer name as a prefix to store the database path. Maybe I'm just not understanding the question :-) PO Box 627 00502 Karen, Nairobi, Kenya. Mobile: +254 722 996532 Fixed: +254 20 2050859 [EMAIL PROTECTED] _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marselle Sent: 01 May 2008 10:57 p To: [email protected] Subject: RE: [delphi-en] Re: Deployment of a Access DB based application using installshield express yes assuming he is running it on the local hard drive Chris.. but if he runs it on a client server environment should return the same results by extractfilePathf(param(0)) + DBName hard to determine with the information he has provided in my opinion --- On Thu, 5/1/08, Chris <[EMAIL PROTECTED] <mailto:jangita%40jangita.com> com> wrote: > From: Chris <[EMAIL PROTECTED] <mailto:jangita%40jangita.com> com> > Subject: RE: [delphi-en] Re: Deployment of a Access DB based application using installshield express > To: [EMAIL PROTECTED] <mailto:delphi-en%40yahoogroups.com> ps.com > Date: Thursday, May 1, 2008, 1:35 PM > ADOConnection1.ConnectionString := > cs+extractfilepath(paramstr(0))+'Data\MyDataBase.mdb' > ??? > > > > Will always get the database if its in a subfolder > \data\ from the > executable > > > > PO Box 627 00502 Karen, > Nairobi, Kenya. > Mobile: +254 722 996532 > Fixed: +254 20 2050859 > [EMAIL PROTECTED] <mailto:jangita%40jangita.com> com > > _____ > > From: [EMAIL PROTECTED] <mailto:delphi-en%40yahoogroups.com> ps.com > [mailto:[EMAIL PROTECTED] <mailto:delphi-en%40yahoogroups.com> ps.com] On Behalf > Of Anu Rang > Sent: 01 May 2008 6:17 p > To: [EMAIL PROTECTED] <mailto:delphi-en%40yahoogroups.com> ps.com > Subject: [delphi-en] Re: Deployment of a Access DB based > application using > installshield express > > > > If I put in a relative path in the ConnectionString the > application > fails to build. It comes up with Unable to locate database > file or > something to that effect. I think may be some kind of > registry key > with the path entered at the installation time may have to > be used. I > just dont know how to do this. Hope I find something on the > internet. > > Anu Rang, TotallyFreeEnergy > http://totallyfreee > <http://totallyfreee <http://totallyfreeenergy.freehoxt.com> nergy.freehoxt.com> > nergy.freehoxt.com > > --- In [EMAIL PROTECTED] > <mailto:delphi-en%40yahoogroups.com> ps.com, > Zoran Milenkovic <[EMAIL PROTECTED]> > wrote: > > > > 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://totallyfreee > <http://totallyfreee <http://totallyfreeenergy.freehoxt.com> nergy.freehoxt.com> > nergy.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] > > > > > > > > [Non-text portions of this message have been removed] > > > ------------------------------------ > > ----------------------------------------------------- > Home page: http://groups. <http://groups.yahoo.com/group/delphi-en/> yahoo.com/group/delphi-en/ > To unsubscribe: delphi-en-unsubscri <mailto:delphi-en-unsubscribe%40yahoogroups.comYahoo> [EMAIL PROTECTED] > Groups Links > > > __________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile. <http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ> yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
