Re: How to summarize recordset...Select Distinct alternative?

Bob Barrows [MVP] wrote:
Tip: use a client-side recordset
'this needs to be done before opening the recordset
oRsPcmkCountAll.cursorlocation = adUseClient

and disconnect it before processing it (after opening it)
Set oRsPcmkCountAll.ActiveConnection = Nothing
'close the connection at this point - it's no longer needed

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: ADO AddNew fails to add first record.
    ... CursorType property after opening the recordset to see what it ... Microsoft MVP - ASP/ASP.NET ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Data file only opened by 1 app.
    ... FileStream myStream = File.Open(FileName, FileMode.Open, FileAccess.Write, ... John Timney (MVP) ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: opening word attachments from email
    ... I disagree - the lazy answer is not taking a few seconds to save to ... Granted opening the attachment directly if you simply want to view the ... Microsoft Office MVP ... MVP FAQ site: http://mvps.org/ ...
    (microsoft.public.word.application.errors)
  • Re: Clearing a Table (Access MDB file)
    ... they will have the DSL going again when I get home tonight. ... Phillip Windell [MCP, MVP, CCNA] www.wandtv.com "Bob Barrows" wrote in message ... This email account is my spam trap so I> don't check it very often. ...
    (microsoft.public.inetserver.asp.db)
  • Re: How do you get the form to automatically go to a new record?
    ... Van T. Dinh ... MVP (Access) ... I need the main form when opening to go to a blank/record, ...
    (microsoft.public.access.forms)