Connecting to an mdb

From: Chris (chrisw_14_at_hotmail.com)
Date: 09/22/04 

Date: 22 Sep 2004 07:05:06 -0700

I am a VBA programmer but have something that I think I need done in
VB but I think there is more to it than meets the eye (for me at
least).

I want to create a script file as an .exe that links to an .mdb
(Access 2000) backend and run some simple queries. This .exe will run
on a server which may or may not have MS Access on it. I am selling
this script to many companies so I want it to be as simple as possible
to install. Anyway, I am wondering about what I need to install to get
it working. From what I have read, I need to install MDAC 2.8 (if
thats all i can get my hands on) and Jet 4.0 Service Pack 8 (because
MDAC 2.6 onwards don't include Jet). I need MDAC 2.8 because VB will
use ADO, is this correct? And the Jet service pack has the drivers to
connect to an mdb. All I have to do then is make the install program
to install the correct service pack depending on the OS and do the VB
code for this script.
Also, they may have MDAC installed, how can I find this out by code?
I don't want to mess with company machines and updating MDAC could
create a problem for them.
Is it best to create some rules and use if statements eg if MDAC is
lower than 2.6 don't install anything because it has all drivers
required, if no MDAC, install MDAC 2.8 and jet, if MDAC 2.6 or
greater, install jet if not already in.

More details on this can be found at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q271908

Chris

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)
  • 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)
  • Re: Method ~ of object ~ failed error while opening ADODB connection in vb6
    ... Dim strConnectionString as string ... the MDAC or Jet installation is "corrupt" (anything from incorrect ... utility to check the MDAC out. ... if using Vista - you can't install the MDAC as it already comes ...
    (microsoft.public.vb.database)
Loading