ok, this is the deal:

1.I have a form which conects to a SQL server database using remote views and ODBC
2.This form is the same for two diferent companies, only the data is diferent, and, eventhough the databases, remote views and tables are exactly the same name, they are located in different places
3.the sql servers are two diferent servers too
4.our users need to acces both databases from the form with out the need of unload the form and then load the same form but pointing to a diferent database
5.we tried to use a combobox to select which database is the one accessed
6.the problem begins with a remote view , lets name it sh_pass
7.this remote view has 4 records in one database and just 1 record in the other one
8. when the table containing 1 record is the first accessed , no problem, it changes the table path and connections with out a problem
9.the problem begins when the first table is the one containing more records, when switching to the one with less record it gives me an error of "record out of range"
10. what we do to change the path for the dbc? well, we use the data environment.closetables, change the path to dbc and then dataenvironment.opentable, till here the problems doesn't show
11. when refreshing the form, the problems shows up.
12. now we tried to open the form twice with diferent paths and no success, it seems there is a problem with the conection for some reason.

any ideas on how to solve that?