>I left the dbc name, but didn't set path. Does SET PATH TO change the default dir? The thing I'm trying to avoid is changing the default dir because when I create temp tables from SQL, I want them to be created on the local hard drive.
>
>Thanks,
>
>-Michelle

No.. SET DEFAULT TO changes the default directory. IMNSHO this is the best way to go... as you said...

1. set up a directory that contains a 'DATABASES.DBF' file in it.

This will be the working directory that you set up in your StartUp icon in windows.

2. The first thing your app should do is open DATABASES.DBF and provide a picklist to people... (or you can store the last used database in the registry or .ini)

3. SET DEFAULT to the selected directory.

Now, when the user wants to go to a different data set, close all your windows... close anything you may open in the default data sessions. Then close data all.

Then... set default to the new data directory.

SET PATH TO should be used to point to external files that app needs to run, such as class libraries, etc... (not to data files, in my opinion)

As far as work directories and temp files, set up a config.fpw that will point those to c:\temp or whatever.

BOb