Path question in DB set-up 1

[Monguse]

Now that I learned how to make a DB in code, How can I use a path statement in this line of code (see below) so that the DB is created in the same directory (or created a sub-directory) the as the main program.

sDataBaseName = "C:\Printing.mdb"

I looked through the FAQ's and did some searching in the MSDN (but this is hard to search sometimes) and have not found the answer yet.

Any ideas?

Thanks

 

[engineer2100]

use the App.Path . This must help

 

[Foada]

Like this

sDataBaseName = App.Path & "\Printing.mdb" Anything is possible, the problem is I only have one lifetime.