OFFICE 97..ACCESS ODBC

[PETERFST]

Cannot install Offie 97 onto a desktop with Windows 98 (1st edition). During
setup, it stops and states that it cannot find the ODBC for Access. In the
control panel I find ODBC "stuff", but not the 32 bit driver (which I assume
I need). What to do? Am going to try and find the driver on the Net, but
basically I am miffed.
A little over my head I fear.

 

['69 Camaro]

Hi.

Cannot install Offie 97 onto a desktop with Windows 98 (1st edition).
During
setup, it stops and states that it cannot find the ODBC for Access.

Did this computer once have a Corel application installed, which was
subsequently uninstalled? That would be one of the reasons why you'd see
this error.

What to do?

Install Microsoft Data Access Components (MDAC) 2.5 SP-3 (which contains the
Jet DLL's) and MDAC 2.8 SP-1. Please see the following Web page for
download links:

http://msdn2.microsoft.com/en-us/data/aa937730.aspx

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[PETERFST]

Thanx for responding.
Arvin wrote:

If I remember correctly, Access 97 has earlier DLLs than the ones that Gunny
describes, but it certainly won't hurt to try. Before doing anything else
though, I'd uninstall Office 97, reboot, then run Regclean.exe (should be on
the Office 97 CD). Then reboot again and try re-installing Office. If you
are still having problems, try Gunny's solution.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Agree? Peterfst

 

['69 Camaro]

Hi.

Agree?

It certainly won't hurt to clean up the partial install and start over, as
Arvin suggests. That's what I'd do (or reinstall the system from backup,
whichever takes the least amount of time). When an installation is aborted,
it's a good idea to clean up any loose ends before starting over.

My experience with missing ODBC drivers is to install the latest version of
MDAC, which fixes it. However, the latest version of MDAC is missing the
Jet components and a few other things, which MDAC 2.5 SP-3 contains.
Therefore, MDAC 2.5 should be installed before MDAC 2.8. In my experience,
Office 97 installs on this configuration and runs without further problems
after all the updates are installed.

If I were in your shoes, I'd do the cleanup first, then install both MDAC's,
then install Office 97 from CD, then install Office 97 SR-2 and other
updates, particularly Jet 3.51, which isn't included in MDAC, but it's
required for Access 97. However, skipping the MDAC installs would take less
time and avoid possible incompatibilities with the earlier DLL's that Arvin
mentioned.

Please see the following Web page for more information on the possible
incompatibilities with MDAC 2.5 (some queries may need to be rewritten due
to different behaviors in the Jet versions, so please read the entire
article to see whether or not the examples given are similar to your
existing queries):

http://support.microsoft.com/kb/237994/

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[PETERFST]

Well, I listened to both of you and it worked. First, I ran Regclean, then
ran mdac _ typ.exe which installed the driver I was missing. Then the install
of Office 97 went as usual.

THANKS to both of you.

Peter in SLC

 

['69 Camaro]

You're welcome. Glad you got it working satisfactorily.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.