Results 1 to 2 of 2

Thread: ADODB error (newbie)

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Sep 2002
    Posts
    146

    ADODB error (newbie)

    Code:
    Dim con As New ADODB.Connection
    
    
    
    
    
    
    Private Sub Form_Load()
    con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\User\Desktop\i-Analysis\Analysis.mdb;Persist "
    
    Dim rs As New ADODB.Recordset
    
    rs.Open "select * from IATestDetails", con, 3, 3, 1
    End Sub



    The table "IATestDetails" clearly exists in the database "Analysis.mdb"..


    What is the problem?
    Attached Images Attached Images  

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