Re: Problem accessing Access database from VB2005

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance




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@xxxxxxxxxxxxx> schreef in bericht
news:qnb7e4pfabmkfp6s75al6m9i9jgb7hdpgk@xxxxxxxxxx
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.OleDB. 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


.



Relevant Pages

  • Re: Trying to install VB6 in Vista
    ... DO compromise to include all the necessary libraries from VB to run on Vista ... I supposed MDAC is also a necessary library for VB. ... BTW why don't you install SP6 intead of SP5? ... service pack 5, it stops with a prompt telling me I have to have MDAC ...
    (microsoft.public.vb.general.discussion)
  • Re: WDAC 6.0 / MDAC 2.x headaches
    ... but MDAC 2.x on other platforms. ... So when we develop and run on Vista, ... TFS2008 build server running Win2003 breaks the DAC 6.0 references ... installation on our customer's Win2003 servers? ...
    (microsoft.public.dotnet.framework.interop)
  • Re: .Net OleDb and Windows Vista
    ... Windows Vista premium contain Windows DAC that is the euivalent of MDAC. ... Links for SQL Server Books Online: ...
    (microsoft.public.data.oledb)
  • Re: Problem accessing Access database from VB2005
    ... assembly file "MSADOXASM.dll" ... Vista has WDAC, and WDAC has no ADOX and you can`t install MDAC (as it ... and then copy the resulting assembly to the vista machine ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Databound Combo Box Not Displaying Entries
    ... What file should I look for for Jet to compare? ... Neither of you are using Vista. ... install MDAC or Jet.) ...
    (microsoft.public.vb.general.discussion)