Bob,
I did a little experiment to, I opened each view to modify and then minimized it, after opening the 10th or 11th view, it would come back with the error, To many connections open.
I'm totally confused. Thanks
Gary
>Have you verified in the remote view designer that share connections is set to true? By default this will be false. Also, if you are using SQL Server, you can use Enterprise manager to check server activity and if you look at the details of the multiple connections you have, you can see the actual SQL statement that was last used by the connection. I open up some 20 - 30 views in my application and always only have 2 connections (one for SQL pass-through to use and one that the views open)