Results 1 to 6 of 6

Thread: [VB6] - Connect an Ms access 2010 dbase to a VB6 project issue

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Aug 2009
    Posts
    64

    [VB6] - Connect an Ms access 2010 dbase to a VB6 project issue

    I used to use this code bellow for accessing an access 2007 dbase but it looks like 2010 is not the same.
    I'm also on windows 7 64

    I have this error:
    Runtime Error 3709
    The Connection Cannot be used to perform this kind of operation.
    it is either closed or invalid in this context

    I think the issue is with this part of the code but i dont know why:
    Code:
    oRST1.Open Conns, Conn
    Can you please help me?

    Thanks again

    Code:
    Dim Conn As ADODB.Connection
    Dim Conns As String
    Dim oRST1 As ADODB.Recordset
    Set oRST1 = New ADODB.Recordset
      
    Set Conn = New ADODB.Connection
    Conns = "Provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source=" & Form2.txtBaseDelabsolution.Text
    Conn.ConnectionString = Conns
    'Conn.Open
    nom.AddItem ""
    oRST1.Open Conns, Conn
    Do Until oRST1.EOF
      nom.AddItem oRST1("Nom")
      oRST1.MoveNext
    Loop
    Last edited by wilder1926; Aug 17th, 2012 at 03:58 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width