Re: Application using Jet provider

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

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 11:33:52 -0500

On Fri, 23 Jul 2004 08:25:37 -0600, "Michael Byrne" <news@2paw.com> wrote:

¤ I agree with you that a .NET implementation might be ideal from my vantage
¤ point as a developer.
¤
¤ However, given the facts of the situation, are there any others out there
¤ with suggestions as to the ADO versions and provider to use with
¤ VB6/ADO/Access. Just looking at the latest Installshield module for Jet
¤ 4.0, it is 15M...which I have to include just in case the user doesn't have
¤ it on their machine. Is there a different provider inside the MDAC 2.7 or
¤ 2.8 installation that I should be using for Access? If not, why did they
¤ stop including the Jet drivers in the Data Access Components install?

There is no other provider so you have to use Jet for an Access database. There are different
variations of Jet which is probably why they removed it from the MDAC package a few versions ago.

¤
¤ Are there more elegant ways of doing this? I don't really want to have my
¤ download be 26M, but I also don't want to have the user try to go through a
¤ checklist of "if you have this, install this...if you don't have this, you
¤ must go here, etc" just to have a trial of my application.

Not sure whether you will have a choice if you are distributing to different versions of the OS.
However, I would consider distributing only the latest version of MDAC.

The only other alternative would be to build a custom setup for your application with Wise or
InstallShield that will detect the OS version and install the appropriate packages.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • Re: Application deployment with Jet Database 4.0
    ... Basically you would install Jet in the same way as MDAC: ... exe that will launch the Jet setup before launching your msi. ...
    (microsoft.public.dotnet.framework.setup)
  • 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: 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)
  • Connecting to an mdb
    ... I am a VBA programmer but have something that I think I need done in ... I am wondering about what I need to install to get ... MDAC 2.6 onwards don't include Jet). ...
    (microsoft.public.vb.general.discussion)
  • Re: Failure to open database
    ... I had suspected MDAC and/or Jet and had sent him instructions to download ... and install - here is the reply that I got. ... MDAC 2.8 and Jet 4.0. ...
    (microsoft.public.vc.database)