Re: Run-time Error 3704 in VB6

From: Gérard Leclercq (gerard.leclercq_at_pas-de-mail.fr)
Date: 12/08/04


Date: Wed, 08 Dec 2004 12:01:53 GMT


Which error?
Be sure there is data for each user

If rst_account_data.Eof = False then
    If rst_account_data.RecordCount > 0 Then <!-HERE IS WHERE ERROR
OCCURS-!>
      rst_account_data.MoveFirst
    Do Until rst_account_data.EOF
End If

> ...
>
>
> At this point for certain queries it reports that "the operation is not
> allowed when the object is closed."
>
> I assure you that the recordset is still open. Please Help! It was working
> fine I think until we upgraded to SQL 2000 a few months back
>



Relevant Pages

  • Re: Translate SMS Report SQL to Access
    ... Using SMS 2003 SQL Views to Create Custom Reports ... into Access to use the data in miscellaneous queries. ...
    (microsoft.public.sms.misc)
  • RE: Recordset as SQL table
    ... Online" of SQL Server 2000 you can find statements like ... When I collect data for my webpage I allways turn the recordset into XML ... > define a number of queries that are then used in other queries just as if ... not a string. ...
    (microsoft.public.scripting.vbscript)
  • Re: Translate SMS Report SQL to Access
    ... Using SMS 2003 SQL Views to Create Custom Reports ... These reports display as tables in my web browser, ... into Access to use the data in miscellaneous queries. ...
    (microsoft.public.sms.misc)
  • Re: Access 2007 - Anyone having trouble with really large conversions?
    ... I have a fairly large app, ... program, which has added even more forms, queries and linked tables. ... get errors when opening a recordset for a linked table. ... So Access 2007 always seems to use Recordset2 objects for its forms and reports ...
    (comp.databases.ms-access)
  • Re: sms 2003 use queries as basis for reports
    ... Queries are based on wmi Query language (WQL), Reports are based on SQL. ...
    (microsoft.public.sms.admin)

Quantcast