VB 6.0 with Access 2007
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5

Thread: VB 6.0 with Access 2007

  1. #1
    Join Date
    Mar 2009
    Posts
    1

    VB 6.0 with Access 2007

    I have previously written a VB6 program which accesses an Access database. Since I've updated to Access 2007, I can no longer test the program.

    When I run the "EXE" of the program, it works fine.

    When I try to test (run) the program within Visual basic 6.0, I get the following message"

    "couldn't find installable ISAM"

    Is there something I need to change/replace/upgrade in Visual basic 6.0, to make it testable???

    Thanks - Tom

  2. #2
    Join Date
    Jan 2006
    Location
    Chicago, IL
    Posts
    14,987

    Re: VB 6.0 with Access 2007

    Show the connection string that you use. Another option is LATE BINDING, so that it doesn't matter which version of Office your program uses, as long as it finds one
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  3. #3
    Join Date
    May 2009
    Location
    Boise Idaho
    Posts
    6

    Re: VB 6.0 with Access 2007

    I had a similar problem when I first switched to Access2007 (when trying to connect to .accdb database files).

    If you were using the Microsoft DAO 3.6 Object Library, try removing the reference to it and instead, set a reference to Microsoft Office 12.0 Access database engine Object Library.

    This solved the issues for me.

  4. #4
    DataMiser is offline Super Moderator Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    4,845

    Re: VB 6.0 with Access 2007

    DAO ... uugh.

    I use ADO and have not had any problems with any version of Access database

  5. #5
    Join Date
    Jan 2006
    Location
    Chicago, IL
    Posts
    14,987

    Re: VB 6.0 with Access 2007

    Download the link in my signature, and get fully working code that shows how to write to controls without having to use BOUND CONTROLS.
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

Posting Permissions

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


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This is a CodeGuru survey question.


Featured


HTML5 Development Center