>I want to choose the path of the databases (3) in a form.
>
>In each local computer, I have a table who have: company, menu, directory
>
>In the main menu there is a form where the user can select the database of that company. (all databases have exactly the same structure but differents paths.
>
>When the users choice a conpany, I CLOSE ALL, send a PATH command with the database´s path, the forms,menus and rest of staff paths, and open the databases again
>
>I have all the forms EXCLUDED from the project
>
>The users have their private directory for temp files and indexes (I use CD "c:\temp" to do it).
>
>Sometimes, the views doesn´t work, others the program goes crazy with tables and databases....
>
>Am I wrong?
>
>Is there a better way to do it?
>
>thanks.
The proven method is to reset Database property (using appropriate path) for all cursors in DataEnvironment.BeforeOpenTables event.
Edward Pikman
Independent Consultant