ADO and TCPIP Connections

Hi,

I have some ADO query's that get opened and as soon as I open a query that
is set to be a server side cursor, every query opened after that onme opens
a new TCPIP connection.

Is there a way to stop this as it some times goes up to the around a 1000
TCPIP connection (or so I have been told).

Could anyone shed some light on this for me please?

Thanks


.

Relevant Pages

  • Query with parameter taken from a user-updated form control.
    ... control's value as a parameter to run a crosstab query. ... using the default date when it opens. ... the Requery method can only refresh the current cursor. ...
    (microsoft.public.access.queries)
  • Re: Discrepency between SQL/MP Explain plan, actual sequence of IOs
    ... It opens a cursor consisting of a two-table inner join, ... Operation 2.1) Hash join the result to the result of Operation 1. ... So then it's just a few dozen fetches until we hit end of cursor or fill up ... The query must not have an ORDER BY. ...
    (comp.sys.tandem)
  • Re: conditional formatting in form slows down calculations
    ... >> table to see all dates and a filtered query to see recent dates. ... If I set it to open with the record source the query, ... >> endless calculating when the form opens. ...
    (microsoft.public.access.forms)
  • Re: Filtering records in a form
    ... I have one query, QrySelMainData, pulling data from TblMainData. ... Switchboard Manager to create a switchboard type menu for you. ... form as the form to open when the database opens. ... I have a database of Issues entered by my agents. ...
    (microsoft.public.access.forms)
  • Re: Query Design View is Slow to Open
    ... same query takes about 20 minutes to open in datasheet view. ... took only seconds to open in both design view and datasheet view. ... The troublesome queries are based entirely on local tables (i.e. no ... HOUSEHOLD_PersonalInfo opens slowly in design ...
    (comp.databases.ms-access)