Find database path

[Reyhaney]

hello every one

I have simple question, in my source ,i use a database that i defined its path in c:/ but now i want to change it where ever user save the database,i mean the program itself find it,i think i must use App,is it correct? how?

thanks

[mabubakarpk]

You have to write app.path but use have to put database file in that folder from where exe file is running.Other wise you can store path in text file where ever user put database file only change the path in textfile and run ur application

[vijaydiwakar]

hello every one

I have simple question, in my source ,i use a database that i defined its path in c:/ but now i want to change it where ever user save the database,i mean the program itself find it,i think i must use App,is it correct? how?

thanks

yes
use app.path or u may place it whever u want then run thy search engine and get the path

[kscmjo]

Provided your database is on the same folder as the application, simply take out the path altogether. ie If the current path is c:\myapp\mydatabase.mdb just call it mydatabase.mdb. Make sure that any icon to your app has the start-in folder the same as the target folder.
I have had problems in Vb6 using app.path as it often returns a UNC path (on networks). ie if the app is run on X:\MyFolder\MyApp (X is mapped to \\server\c-drive) app.path will return \\server\c-drive\MyFolder where I want X:\Myfolder.
To overcome this when my app starts I set a global variable callled MyAppPath to the current directory MyAppPath=CurDir. This always returns the mapped drive letter.