Results 1 to 5 of 5

Thread: "Could not find Installable ISAM"

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2001
    Location
    India
    Posts
    203

    "Could not find Installable ISAM"

    Im trying to import Data from an Access DB to an Excel Spreadsheet, the Code gives me the error

    Run-time error '-2147467259(80004005)'
    Could not find Installable ISAM

    on the line cn.Open...

    VB Code:
    1. Dim cn As ADODB.Connection, rs As ADODB.Recordset, intColIndex As Integer
    2.     ' open the database
    3.     Set cn = New ADODB.Connection
    4.     cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
    5.         tstDBFullName & ";" & "UID=myuname ;PWD=xyzu "
    6.     Set rs = New ADODB.Recordset

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,710

    Re: "Could not find Installable ISAM"

    Your Access connectionstring should be without the spaces and pwd should be Password.
    VB Code:
    1. cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & tstDBFullName & ";User Id=admin;Password=;"
    Whats the value for tstDBFullName?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  3. #3
    Addicted Member
    Join Date
    Jan 2002
    Location
    Glasgow, Scotland
    Posts
    202

    Re: "Could not find Installable ISAM"

    i would look on Microsoft support..:

    http://support.microsoft.com/default...b;en-us;283881
    if you fail to plan, you plan to fail

  4. #4

    Thread Starter
    Addicted Member
    Join Date
    Aug 2001
    Location
    India
    Posts
    203

    Re: "Could not find Installable ISAM"

    Quote Originally Posted by Br1an_g
    i would look on Microsoft support..:

    http://support.microsoft.com/default...b;en-us;283881
    I had already gone through those steps on the page but thanks anyways.

    The spaces and password did get me out of the ISAM error but now can anyone tell me how to incorporate a workgroupd file here for this authentication coz it says tht the workgroups information file is missing or opened exclusively by another user.

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Aug 2001
    Location
    India
    Posts
    203

    Re: "Could not find Installable ISAM"

    nevermind the workgroup problem.....I fixed it by adding

    Jet OLEDB:System database=C:\SYSTEM.MDW;" at the end

    so its now
    VB Code:
    1. cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBFullName & ";User Id=manektalau1;Password=;Jet OLEDB:System database=C:\SYSTEM.MDW;"

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