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

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


    The following code does not work:

    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"
    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?

    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