Re: Creating an Office XP compatible database?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: dkomo (dkomoNoSpam_at_cris.com)
Date: 03/31/04 

Date: Tue, 30 Mar 2004 17:08:50 -0700

Phillip Windell wrote:
>
> You need to use Jet 4.0
>
> My VB6.0 has Jet 3.51 and 4.0 and I didn't do anything special to make it
> happen that way. I suppose just updating to the newest MDAC Components you
> can run on your machine will do it,..that is all I have ever done.
>
> If your current MDAC is older than 2.5, I believe I upgraded it with
> MDAC2.5-SP2 first then went up to MDAC2.7. There was a "cutoff" in there
> somewhere where the Jet engine wasn't included. Version 2.5 sp1 may have
> been the last one to include it. The details are fuzzy to me, but MS's site
> should have the details when you find thier MDAC "stuff".
>
> --
>
> Phillip Windell [MCP, MVP, CCNA]
> www.wandtv.com
>

I'm almost sure I've got Jet 4.0 because the install of Office XP must
have put it there. What are the file names for Jet so I can check?
Also, how do I find what version of MDAC I have installed?

But assuming I do have Jet 4.0, how do I specify that using DAO? It
is apparently picking up Jet 3.51 from my CreateDataBase statement,
but there is no system constant like dbVersion30 for Jet 4.0. I know
you can specify Jet 4.0 in an ADO connection string, but I don't feel
like converting all my DAO statements to ADO.

       --dkomo@cris.com

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)