Thank you Mary.
It seems that I have no chance to force the Access to do
it serially... Good MS strategy to force me to buy full
Thanks once more.
>>if your form has 3 bound combo boxes, then when the form
>>queries are running simultaneously. If the result sets
are large, then
>>running them serially on a single connection would take a
>>and performance would be unacceptable. With MSDE you have
>>performance throttle with 5 concurrent batches, so you'll
want to code
>>your app accordingly. IOW, fetch only needed data and
stay away from
>>large result sets.
>>Microsoft Access Developer's Guide to SQL Server
>>On Mon, 29 Sep 2003 12:28:22 -0700, "Zb"
>>>why my ADP application makes more than one simultaneous
>>>connections to SQL server? Is there any way to control
>>>maximal number of connections being created?
>>>I use Access 2000 and MSDE.