>What is the best solution to let your exe no where the database files are stored on the hard disk. It is a pain in the but to hard code this every time you move your databse to a different directory or drive?

keep them in a directory under the executable. from this, include the data directory in you path statement