In putting together an app, I ask the user for a project number upon startup. If the project does not exist, I'd like to replicate the DBC and it's tables in a sub-directory and use that as the data for my main application.

I'm wanting to do this for easy backup, organization and archiving - and to make it easier for users to manage their files.

That being said, I'm having trouble figuring out how to create the data environment of my primary application. How do I tell my form to look in a certain directory for it's DBC, instead of the one I used for design? Do I need to empty the data environment and instead open the tables and create the relationships in the calling program? I know this is the way I always used to do it - perhaps I'm just getting lazy!

TIA