Problem accessing Access database from VB2005

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • John Dann
    #1

    Problem accessing Access database from VB2005

    We've got a VB2005 program written some time back that we're trying to
    do some maintenance on still from within VB2005 but now running on a
    Vista Business PC (which I think may be relevant to the problem).

    When we go to start up the project from within the VS environment
    there are several build errors relating to an inability to find the
    ADOX library. I can't remember without hours of reorientation and
    checking back whether this was a part of MDAC or should be accessible
    from System.Data.Ole DB. If it was MDAC then this is something that may
    have changed in a Vista environment because IIRC the traditional MDAC
    calls no longer work in the same way.

    Anyone recognise this problem please and can suggest a fix?

    Many thanks
    JGD
    Tags: None
    • Michel Posseth [MCP]
      #2
      Re: Problem accessing Access database from VB2005


      Vista has WDAC , and WDAC has no ADOX and you can`t install MDAC ( as it
      is a lower version )
      see this thread
      http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=974386&SiteID=1


      the solution seems to be to use
      tlbimp msadox.dll /out:ADOX28.dll

      Then put this ADOX28.dll file on your development machine and add reference
      to it.


      however you should do this on a XP computer wich has MDAC 2.8 installed and
      then copy the resulting assembly to the vista machine
      ( this is how i understood it )

      regards
      Michel Posseth [MCP]
      http://www.vbdotnetcoder.com








      "John Dann" <news@prodata.c o.ukschreef in bericht
      news:qnb7e4pfab mkfp6s75al6m9i9 jgb7hdpgk@4ax.c om...
      We've got a VB2005 program written some time back that we're trying to
      do some maintenance on still from within VB2005 but now running on a
      Vista Business PC (which I think may be relevant to the problem).
      >
      When we go to start up the project from within the VS environment
      there are several build errors relating to an inability to find the
      ADOX library. I can't remember without hours of reorientation and
      checking back whether this was a part of MDAC or should be accessible
      from System.Data.Ole DB. If it was MDAC then this is something that may
      have changed in a Vista environment because IIRC the traditional MDAC
      calls no longer work in the same way.
      >
      Anyone recognise this problem please and can suggest a fix?
      >
      Many thanks
      JGD

        Comment

        • Michel Posseth [MCP]
          #3
          Re: Problem accessing Access database from VB2005

          Okay here a folowup



          Copy the "%Program Files%\Common Files\System\ad o\msadox.dll" from working
          XP machine to Vista machine

          Execute "tlbimp msadox.dll /output:MSADOXAS M.dll" . This will create the CLR
          assembly file "MSADOXASM. dll"

          Add this assembly to your project and add the "using MSADOXASM;" statement
          to your code.

          and the problem should be solved


          HTH

          Michel Posseth
          http://www.vbdotnetcoder.com













          "Michel Posseth [MCP]" <MSDN@posseth.c omschreef in bericht
          news:uDswKXAJJH A.5704@TK2MSFTN GP02.phx.gbl...
          >
          Vista has WDAC , and WDAC has no ADOX and you can`t install MDAC ( as it
          is a lower version )
          see this thread
          http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=974386&SiteID=1

          >
          the solution seems to be to use
          tlbimp msadox.dll /out:ADOX28.dll
          >
          Then put this ADOX28.dll file on your development machine and add
          reference to it.
          >
          >
          however you should do this on a XP computer wich has MDAC 2.8 installed
          and then copy the resulting assembly to the vista machine
          ( this is how i understood it )
          >
          regards
          Michel Posseth [MCP]
          http://www.vbdotnetcoder.com

          >
          >
          >
          >
          >
          >
          >
          "John Dann" <news@prodata.c o.ukschreef in bericht
          news:qnb7e4pfab mkfp6s75al6m9i9 jgb7hdpgk@4ax.c om...
          >We've got a VB2005 program written some time back that we're trying to
          >do some maintenance on still from within VB2005 but now running on a
          >Vista Business PC (which I think may be relevant to the problem).
          >>
          >When we go to start up the project from within the VS environment
          >there are several build errors relating to an inability to find the
          >ADOX library. I can't remember without hours of reorientation and
          >checking back whether this was a part of MDAC or should be accessible
          >from System.Data.Ole DB. If it was MDAC then this is something that may
          >have changed in a Vista environment because IIRC the traditional MDAC
          >calls no longer work in the same way.
          >>
          >Anyone recognise this problem please and can suggest a fix?
          >>
          >Many thanks
          >JGD
          >
          >

            Comment

            • John Dann
              #4
              Re: Problem accessing Access database from VB2005

              Many thanks - I'll check this out asap.

              JGD

                Comment

                Previous template Next
                Working...