On the Microsoft Knowledge Base: www.microsoft.com/kb, there is an article on how to programatically change file locations in a data environment.

Here are a few links:

http://support.microsoft.com/support/kb/articles/q160/9/16.asp
http://support.microsoft.com/support/kb/articles/q142/8/85.asp


>The database I developed will be installed on a network on a drive other than C:. It will run in runtime environment. How do I resolve the "database has moved" message I get when starting it in the non-development environment?