VB using ADO to access Microsoft Access 97.

[Dariusz Tyszka]

Ok, I know I should not use Access 97 with Vb anymore. But
if I do, I always thought that I can include mdac_typ.exe
file in the installation package and that will work. It
does but not always. If it doesn't, I download mdac 2.5
and install that separately. The problem I have with
Windows XP pro. First of all, the program does not work
after the installation. Then, I cannot install mdac 2.5. I
tried to install Jet 4.0 but it does not let. What should
I do? If I install mdac 2.6 in addition to jet 4.0, will
that work?

 

[Douglas J. Steele]

It should. However, I though your problem was that you couldn't install the
Jet 4.0 SP. How will installing MDAC 2.6 solve that?

 

[Dariusz Tyszka]

Mdac 2.6 and up does not include jet engine. I have read
somewhere on Microsoft download site that when installing
jet 4.0 on Windows XP, you need to install mdac 2.6. I
don't know if that is true or not. My VB application uses
OLEDB 3.51 to access Access 97. When installed on Windows
XP pro, the provider is missing. I tried to instal mdac
2.5 and I got message that is already installed. I hope
that installing jet engine 4.0 will help. Since I don't
use OLEDB 4.0, will jet 4.0 work? Or, what else I can do.
Please hep - this is important.

 

[Douglas J. Steele]

It's not a case that when installing Jet 4.0, you need to install MDAC 2.6,
but the other way around (If you install MDAC 2.6, and you want to get at
Jet databases, you need to also install the Jet 4.0 service pack).

If you install the Jet 4.0 service pack, you'll need to change your
connection strings from OLEDB.3.51 to OLEDB.4.0, since the Jet 4.0 service
pack doesn't install the 3.51 provider. However, Jet 4.0 is backwards
compatible, and will work with Jet 3.5x databases (although it may be a
little slower since it'll be doing unnecessary conversions to and from
Unicode).

In your original post, though, you imply that you tried to install the Jet
4.0 Service Pack already, and it didn't work. There's really no correlation
between MDAC 2.6 and Jet 4.0 SP, so if you've already encountered a problem,
I don't think installing MDAC 2.6 will resolve it.

What was the error when you tried to install Jet 4.0 SP previously? Check
out http://support.microsoft.com/?KBID=282010