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.