>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?
Matthew,
What I do is to create a directory (under VFPPROJECTS) for a project and a data, report etc dir under it. Dir struc looks like something like this :

..\MyProj
..\MyProj\Data
..\MyProj\Report

I put all dbc,dbf and alike in data dir. Also my config.fpw or startup.prg has "set path to data;report;". Notice that here paths are relative to current dir. I move my dir to anywhere on disk preserving data and report dirs exist under app dir. So app always uses its "own" data dir.
Cetin