>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? SET PATH TO blah, blah, blah You can softcode this into a table so the first program that runs pulls the paths from a table it "knows" how to get to. OR Write the path to the registry and just recall it.