Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004
    Posts
    47

    Unanswered: ADO code doesnot work, please help!!!

    Hi,

    The following code does not work:

    Code:
    Public Sub ADOOpenDatabase()
    
    Dim cnn As ADODB.Connection
    Set cnn = New ADODB.Connection
    
    cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\db1.mdb;Persist Security Info=False;Exclusive=0"
    cnn.Close
    
    End Sub
    I get the following error:
    -2147467259 (80004005) Cannot find installable ISAM

    I have Microsoft Access 9.0 Library, ActiveX Dataobjects 2.8 Library, Microsoft DAO 3.6 Object library and , ADO Extension 2.8 Library referenced.

    1. Can someone help with what needs to be loaded?
    2. My help files on ADO are not working. Is there somewhere where I can download it from?


    Regards
    Last edited by Kashizzz; 05-04-04 at 08:00.

Posting Permissions

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