I have been trying to find a way to get the path of a DB coded into a VB6 application to no avail. I have the concept of hard coding the path but I will soon be distributing the application and the end users may not (probably will not) save the application in the path that I hard cade. To that end I need a way to code the path to search for and connect to the appropriate DB. I have looked and have so far been unable to find a solution any assistance you can provide would be greatly appreciated.

Kenny Alligood

__________________
Kenny Alligood

If the db is installed to the same directory as your app (or a subdirectory), you can just use App.Path within your vb code to locate the db.

If its somewhere else, you can try putting the path in the registry, or creating a DSN that contains the path and using that to connect to your db.

hth
Phil

Thanx for the reply Phil but I am looking for a way to connect when the DB is installed somewhere other than the folder that contains the application. Is there a routine that can search for it and connect or something similar? Thanx again and I appreciate any thoughts you may have.

Kenny Alligood

As I said before "If its somewhere else, you can try putting the path in the registry, or creating a DSN that contains the path and using that to connect to your db."

OK. Thanx again

Kenny Alligood