Deploying VB6 + DAO 3.6 + JET 4.0?

[Kjell]

Hi,

We have an Access DB that our customers subscribe to. A new version is
issued every month. Along with the DB we ship a small data selection tool
written in VB 6 that uses DAO 3.6 and Jet 4 to access the DB.

I need to create an MSI installer for this. Where can I find:

1. Merge modules that contain exactly those runtimes I need for DAO 3.6 +
Jet 4 + whatever VB6 uses to connect to DAO 3.6?

2. As an alternative: documentation so that I can pick the correct files
myself and install them in the correct way?

I have not been able to find this myself. I would have expected Microsoft to
prive a merge module for all of their runtime packages. It seems they don't?!?

Thanks,
Kjell

 

[Guest]

Jet 4 isn't a runtime package. It is part of the standard Windows install.

Windows 3.1, 95, and 98 did not include Jet, but those Windows
versions are no longer supported by MS.

(david)

 

[Kjell]

I'm not sure what the OP means but as regards your reply I'd like to
point out that Jet 4.0 is still available for redistribution.

Jet plus its OLE DB providers etc used to ship with MDAC. The last
version of MDAC to ship with Jet was MDAC 2.5, which is still
available as a download:

Microsoft Data Access Components (MDAC) 2.5 Service Pack 3
http://www.microsoft.com/downloads/...e9-dde7-4a60-b586-5d4fd6794db6&DisplayLang=en

This article:

MDAC version 2.6 and later do not contain Jet or Desktop ODBC drivers
http://support.microsoft.com/kb/271908

states, "If you are installing MDAC 2.6 or later, and you want to
install the Jet components, follow the instructions in article 239114
to download a redistributable version of Jet 4.0 Service Pack 8
(SP8)."

The important phrase here is "download a redistributable version of
Jet 4.0". Here is that article:

How to obtain the latest service pack for the Microsoft Jet 4.0
Database Engine
http://support.microsoft.com/kb/239114

Thanks, but that's old news. The problem is that the articles you mention
are no help for an installer. Am I supposed to have to include every possible
OS and language version of the JET 4 and DAO redistributables available from
MS, AND have to code the logic required for the installer to pick the
appropriate package? This is not a viable solution.

But is it true that JET 4 and DAO 3.6 are part of the standard Windows
install for Windows 2000, XP, 2003 and Vista? So, would it actually be
sufficient to specify those as minimum system requirements?

Thanks,
Kjell

 

[Albert D. Kallal]

But is it true that JET 4 and DAO 3.6 are part of the standard Windows
install for Windows 2000, XP, 2003 and Vista? So, would it actually be
sufficient to specify those as minimum system requirements?

Thanks,
Kjell

Yes, as far as I know, you don't need to install anything. for windows xp,
and vista....

as for win 2000...I don't know off the top of my head.....

 

[Aaron Kempf]

are you friggin kidding me?

DAO hasn't been included with Windows.. have you analyzed the security risk
involved with opening trap doors on your client machiens?

move to ADO.. mean.. what is wrong wiith you?

MDB isn't reliable enough for real world usage.. move to Access Data
Projects

 

[Robert Morley]

Why are you resurrecting a month-old thread with your vitriol?


Rob

 

[Aaron Kempf]

BECAUSE I AM RIGHT?

Don't use DAO for anything
DAO hasn't been included with Office, Windows or MDAC for a decade

 

[Aaron Kempf]

why are you resurrecting a decade-old database format and data access
library?