Thanks but that's not the problem. I've always set the second property on SQLSTRINGCONNECT to True, and thanks to Code References, it's easy to check that I didn't miss one. I'm within a week of releasing this application and am becoming very worried that I'm missing some big piece of this puzzle.

Using a string for the CONNSTRING clause of the USE command creates a new connection for each view. it is much slower, but is there a limit to the number of connections that can be created this way? Perhaps I should just accept poor performance.

Using the handle number is 13 times faster when opening multiple views, but results in a Connection Busy message on every view which follows one opened with data. It is as if the command suddenly behaves synchronously.

What am I missing?