Re: Run-time Error 3704 in VB6

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Hickman (fhickman_NOSP_at_M_noblesoft.com)
Date: 12/08/04

  • Next message: Wildlife: "Re: Run-time Error 3704 in VB6" 
    Date: Wed, 8 Dec 2004 12:39:58 -0500

    Well you are closing the result set if the state is 1...perhaps that's the
    reason. 

    -- 
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.
"Wildlife" <Wildlife@discussions.microsoft.com> wrote in message 
news:0DC1A4A6-E3AF-4CFD-A6AF-CA2F7DBC4649@microsoft.com...
> When I step through this piece of code for a user that I know has data, on
> the second line I get the following error:
>
> "Run-time error '3704':
> Operation is not allowed when the object is closed."
>
> cnn_DB.sp_adjust_account Me.ssn_key, rst_account_data
> If rst_account_data.EOF Then MsgBox "Test Me"
>
> I get no error when running the stored procedure line of code.
>
>
> "Gérard Leclercq" wrote:
>
>>
>> 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
>> >
>>
>>
>>
  • Next message: Wildlife: "Re: Run-time Error 3704 in VB6"

    Relevant Pages

    • Re: Outlook 2003 crashing/not closing
      ... The reason that I ask is ... >not closing. ... PDA synchronization software with your PDA in the cradle. ... Mail reminder add-ins that keep a stub of Outlook open in the ...
      (microsoft.public.outlook)
    • Re: Confirm data change on close
      ... closing the form or the application will save any changes. ... There is no real good reason to use a save button. ... For your Exit Button, just use Docmd.Close in the click event. ... to check for changes in the Form's Unload event. ...
      (microsoft.public.access.formscoding)
    • Deprecating ps(1)s -w switch
      ... originator) challenged my reason for closing it. ... The suggestion is that ps's -w switch is a strange artifact that can ...
      (freebsd-hackers)
    • Re: Get the "User pressed close button (in controlbox)" event...
      ... Reason: If for some reason the next version of something makes a new way of ... closing a window - you would have to change your code accordingly. ... and you should take anything else as a cancel. ... just closes the modal form by the forms Close button. ...
      (microsoft.public.dotnet.framework.windowsforms)
    • Re: Run-time Error 3704 in VB6
      ... I am closing it because the next line opens it back up. ... It is consistent with which users it works for and ... "Frank Hickman" wrote: ...
      (microsoft.public.data.ado)