>>>I belive the problem is that if you are using the DE of the form, the PATH of the tables is stored in the form in addition to the table name. So, no matter what the path or default is, you are alway looking at the same tables.
>>>
>>>BOb
>>-----------
>>Thanks Bob... is there another way that allows me to change PATHs.
>
>Well, there are a couple of ways...
>
>1. Hack the .SCX... every Cursor (file) will have a record... that record will have a cursor source, which will have the path in it... delete out the path so only the file name is left. You may be able to write a utility to do this, you may even find one here on the UT. Once this is done, the form having no reference to the files will look in the default directory, then in the FoxPro path to find them.
>
>2. Create code in the Load event of your form class that closes the tables in the DE, then modifies the Cursor properties CursorSource removing the paths, then open the tables again. (once again, see the Files section here)
>
>3. Don't use the forms DE at design time... add the cursors to the DE in the form load.
>
>4. Don't use the forms DE at all.
>
>BOb
----------------
Thanks for the options Bob.... :)