Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Errore ADO run-time -2147024770 (8007007e) (6.0)

    why!!!!!!!!!
    Error ADO run-time -2147024770 (8007007e)

    Have reinstalled jet & mdac 2.8

    when the code go in line in SET sattement...


    Sub uno()
    Dim conn As New ADODB.Connection
    Dim rs As ADODB.Recordset
    Set conn = New ADODB.Connection
    Set rs = New ADODB.Recordset
    End Sub

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Errore ADO run-time -2147024770 (8007007e) (6

    Here is a guess. This statement:

    <code>Dim conn As New ADODB.Connection</code>

    combines these two statements:

    <code>Dim conn As ADODB.Connection</code>
    <code>Set conn = New ADODB.Connection</code>

    So try removing your Set statement, or remove New from your Dim statement to avoid duplication. Does it help?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •