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.