How to connect to Access/Excel files via ADO in MDAC 2.8, and Vista?


Starting with MDAC 2.6, Microsoft dropped support for Jet, and the ODBC Database Drivers.

Does that means that it is no longer possible to connect to Access/Excel files via ADO in MDAC 2.8 or under Windows Vista?

Please advise.

Thank you.
Simon Johnson

.

Relevant Pages

  • Re: Microsoft and trust
    ... Jet was separated from MDAC because MDAC components were not required ... Jet has been in the MDAC packages for many versions. ... When the MDAC package first appeared it was part of Microsoft's ... If I had to decide to move part of a package into a separate package, ...
    (microsoft.public.vb.general.discussion)
  • Re: Microsoft and trust
    ... Jet was separated from MDAC because MDAC components were not required by ... Jet has been in the MDAC packages for many versions. ... The Jet parts were always minor in size compared to the total size of the package. ... I would have told the reasons, what the consequences were, that there is a separate package, describe it, put a link to it and so on. ...
    (microsoft.public.vb.general.discussion)
  • Re: Will Jet 4.0 connection strings work on XP?
    ... Yes Jet has been removed from the latest 'n greatest MDAC_TYP packages. ... I think there might be some confusion about what the MDAC is. ... You can install newer MDAC packages as they become available. ...
    (microsoft.public.vb.database.ado)
  • Re: VB6 / Microsoft Jet Database and 64-Bit Windows Vista
    ... I found out today that Microsoft does not support the Microsoft Jet ... Microsoft killing support for VB6 on Vista? ... You can't install MDAC on Vista. ...
    (microsoft.public.vb.general.discussion)
  • Re: Run time error 3706 Provider cannot be found. It may not be properly installed
    ... I have a few questions regarding reinstalling SP2: ... Jet is no longer released with MDAC since Version ... This error is similar to following KB which describes a situation that Jet ... install MDAC 2.5 SP2, and then upgrade to the latest Jet components. ...
    (microsoft.public.data.oledb)