I am working on a database program that uses the ODBC drivers and my VB6
code uses the line:

    db.open "dsn=members"

members refers to the ODBC location of the database.

Can anyone provide code that I can use that specifies that the database is
in the application path and not the path of the current file as I want to
distribute the program.

Current example:
    ODBC points to C:\DATABASE\filename

I would like the directory of the application:
    C:\PROGRAM FILES\DATABASE\filename