In message < XXXX@XXXXX.COM >, Dave
< XXXX@XXXXX.COM > writes
Sorry to but in but the other poster is wrong...
The JET drivers are NOT guaranteed to be installed on your destination
PC (unless a version of Office is present). You can't even guarantee
that the correct version of MDAC is installed on your target PC. The
problem gets even more complicated when it comes down to different
versions of Windows.
Lets deal with MDAC first (Microsoft Data Access Components):
MDAC is basically where the ADO objects live. Prior to XP you can almost
guarantee version 2.1 of MDAC will be installed. With XP this can be
version 2.6 to 2.8 inclusive. And then there is the service packs to
these versions which depends on whether people having been running
Windows updates. If you have used 2.8 in your program and only 2.1 is
installed then your program is not going to run.
There are installers available on MSDN for all versions of MDAC (EXE's
and MSI's) however, XP does NOT like to install 2.6 onwards unless via
Now as for the JET drivers - contrary to popular belief - they are NOT
included with any version of MDAC. However, there are installers for the
JET drivers (EXE's and MSI's) available on MSDN. I believe some later
service packs for Outlook Express install them.
I would therefore suggest you include these redistributables with your
The other alternative is use a proper package builder like Install
Shield or WISE which can include and subsequently install them if
required or the target PC.
Andrew D. Newbould E-Mail: XXXX@XXXXX.COM
ZAD Software Systems Web : www.zadsoft.com