O97: SR1 won't install!

I have Win 98, OEM version on a new PC along with Office 97, non-OEM installed. I'm trying to install the Office 97 SR2b update on a PC with the SR1 patch. But I keep getting an error:

"The Office 97 SR-2 patch cannot be applied to your computer. Either Office 97 is not installed [it is] on this computer, or there are files from multiple versions of Office 97 on this computer. Try installing Office 97 or running the latest SR-1 patch to correct the problem.[I did.] "

I read up about this problem with SR1 and Win 98 and did the following:
- Renamed walign.exe to walign.e in \windows\system so it wouldn't run. Walign actually changes the files, so SR1 can't recognize them and update them.
- Deleted winword.exe, excel.exe, msaccess.exe, mso97.dll, outllib.dll, powerpnt.exe.
- Reinstalled Office 97 (it was a full reinstall because it asked me for the CD key)
- After entering the CD key, my ID key did not contain "OEM" (which I read is a problem with SR1)
- Rebooted and installed SR1 which I got today from the MS website. (I had read there were several versions of SR1 so I got the file again.)

Then I ran the Office 97 version checker. And I got the error above, which meant the SR1 didn't take. Now when I run the SR1, it appears the SR1 program itself is aligning the files (which changes them). How do I get this SR1 installed?

What I noticed, is in the Registry under HKEY_LOCAL_MACHINE, Software, Microsoft, I have keys for "Office 97 Professional" and "Office". But there is only one version of Office on this PC. How do I fix this? Could this be the problem?

The user is having a problem with Access updating the wrong record. When she changes data in a field of an existing record, sometimes that data is put in the record after the one being edited. User uses a combo box to get the record, and that uses Recordsetclone and Bookmark. I heard there was a problem with Recordsetclone and Bookmarks. SR2b fixes this problem, but I can't install it.

A note on Woody's Office Watch says I need the Enterprise Update from my vendor. Is there another way to get this?

It is critical that this get fixed, because Access changes our data without our knowing it! Help! Thanks.

LVL 1
gigo30Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gigo30Author Commented:
Did I mention when I reinstall O97, it is reinstalled from a Novell network drive? Does it make a difference? We just copied the installation CD to a network drive.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Sounds like your hitting the bookmark bug alright.

  Rather then trying to make what you have work, I think I'd start over by first un-installing A97 full by following the instructions in MSKB article Q163997 ACC97: How to Completely Uninstall Microsoft Access 97.  Note that clicking "remove all" does not cut it.

  After that reinstall using Setup /y.  The /y forces a rewrite of the registry keys.

  Now apply SR-1.

  I'd then double check that you have the lastest SR2 version.  There have been several released (one was released to address install issues over SR1).

  Whatever the problem is, that should clean it up.

JimD.
 
0
gigo30Author Commented:
Why would this work, when it appears that SR1 is realigning the files itself? Even after I renamed walign.exe to walign.e so it wouldn't run. I'll try it but I don't know.

0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Teh reason I think it will work is that you'll be:

1. Removing any .DLLs - If you have mixed DLL versions (ie. from A97 and SR-1), they will all get deleted.

2. By using SETUP /y, you'll be rewriting all the registry keys.  If your registry entires are messed up, this will take care of it.

  In affect, your going back to a "clean slate" as far as Access is concerned.  This should allow the SR's to be installed correctly.

  I've used this procedure many times to correct a varity of problems.  It's only failed once (Microsft bug was the root of the problem, not the current environment).

JimD.
0
gigo30Author Commented:
I uninstalled O97. And followed the directions in the KB article above. Some DLL's didn't get deleted because they were in use by windows. I also didn't delete the Program Files/Microsoft Office directory, or any *.dir files.

I also didn't delete any registry keys because there were settings for MS Publisher in the key area for Office.

When I ran setup /y (I created a shortcut for it) I kept getting an error "Setup did not complete successfully." Then it quit. No other message or anything. So I'm running Setup without the /y switch.

We are running on a Novell network with system policies in effect. I don't know what they are. Could this prevent Setup /y from rewriting the registry?
0
gigo30Author Commented:
Running Office Setup without /y didn't work either. When I ran SR1 it said some files will not be updated, and listed them. So when I ran SR2 it would not install.
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
You need to follow the uninstall article exactly.  If DLLs are in use when you try to delete them, you must reboot and try again.  If their still in use, then it means you have a program in your startup or registry that is starting up with Windows.  You'll need to get rid of it.

  Do not proceed with anything on SR-1 or SR-2 until you can get a clean uninstall and reinstall with the /y switch.  If you do, your just wasting your time.

  The fact that you can't get a succesfull reinstall using /y means there is a problem with the standard install.  Again, follow the MSKB article directions to the letter.  It may mean you'll need to reinstall Publisher (please don't shoot the messenger, it's not my product<g>).

  As far as the system policies, yes certainly they can be messing things up.  I'd try and get someone to remove the policy while your trying to do this.

JimD.

0
gigo30Author Commented:
I ordered the SR2 free CD from MS. Is that a full install of Office 97 which includes SR1 and SR2? Or is it the same as the SR2 I downloaded from the Internet? (Which doesn't work anyway.)
0
gigo30Author Commented:
I'm still confused why the KB article would work when SR1 itself runs Walign before it runs. When I started SR1 it said "adjusting your programs so they run faster" or something like that. And the screen that it showed looked exactly like the one you get when you run walign.exe.

When I get the SR2 CD will I have to uninstall Office 97 first? Then install the CD? It sounds like I may have to uninstall MS Publisher first also. Then install the CD. Then reinstall Publisher.
0
JimMorganCommented:
Publisher is known to cause all kinds of problems with Access 97.  I think that you are on the right track here.  Also be sure to get the newest service pack for Jet, which I don't believe is on the CD.  I had put up a question a few months ago about the various releases.  I don't believe that they have changed since then.  http://www.experts-exhcnage.com/Computers/Databases/Access/Q_10217158.html

Jim
0
JimMorganCommented:
Here is what Microsoft has to say about the problem you seem to be having.  I'd give you the article number but when I did a search, it didn't come up with one on my system.

OFF97: SR-2 Patch Fails Even Though SR-1 Has Been Installed
SYMPTOMS
========

When you install the Microsoft Office 97 SR-2 Patch, you may receive the
following error message:

   Microsoft Office 97 SR-2
   Microsoft Office SR-2 can not locate an installation of Office 97 SR-1
   on this machine. If you are running Office 97 SR-2 from CD-ROM, first
   install Office 97 SR-1 from the CD-ROM. If you downloaded Office 97
   SR-2 from the Web, first install Office 97 SR-1 from
   http://www.microsoft.com/office/office97/ServiceRelease/sr1/
   AboutSR1.asp.

You may receive this error message even though you have already installed
Microsoft Office 97 SR-1 on your computer.

CAUSE
=====

This problem may occur if any of the following conditions are true:

 - The version of one or more of the following files on your computer's
   hard disk drive is earlier than the version of the file included in
   Microsoft Office 97 SR-1:

      Mso97.dll
      Excel.exe
      Winword.exe
      Outllib.dll
      Msaccess.exe
      Powerpnt.exe

    -or-

 - The following key in your registry

      HKEY_LOCAL_MACHINE\Software\Microsoft\Shared Tools\mso97.dll\Path

   refers to an incorrect location for your Mso97.dll file.

    -or-

 - Your downloaded copy of the SR-2 Patch is damaged or corrupted.

RESOLUTION
==========

To correct this problem and allow the SR-2 Patch to update your Microsoft
Office program files, you need to follow all of these procedures:

 - Search for and delete duplicate program files
 - Delete files whose versions are incorrect
 - Verify the Mso97.dll key in your registry
 - Reinstall Microsoft Office 97 SR-1
 - Rerun the SR-2 Patch

NOTE: If you omit any of these procedures, the SR-2 Patch may still not
work correctly. So, it is important to follow them all.

Search for and Delete Duplicate Program Files
---------------------------------------------

If there are two or more copies of any of your Microsoft Office program
files on your computer, the SR-2 Patch may fail. To prevent this problem
from occurring, you must find and delete the duplicate files. To do this,
repeat the following steps for each of the following files:

   Mso97.dll
   Excel.exe
   Winword.exe
   Outllib.dll
   Msaccess.exe
   Powerpnt.exe

   1. On the Start menu, point to Find, and click Files Or Folders.

   2. In the Named box, type the name of the file for which you want
      to search. In the Look In list, click to select My Computer. Then, click
      Find Now.

Typically, the search will return a copy of the file in the following
folder:

   C:\Program Files\Microsoft Office\Office

The search may also return additional files with the same name but in
different folders. Delete the additional files by right-clicking them and
clicking Delete on the shortcut menu. When only one file remains, move to
the next file in the list. If the search returns only one file, do not
delete it; instead, move to the next file in the list.

Delete Files Whose Versions Are Incorrect
-----------------------------------------

If any of your Microsoft Office program files have a version that is
earlier than the version of the files in Microsoft Office 97 SR-1, the
SR-2 Patch will fail.

The SR-2 Patch checks the versions of the following files included in
Microsoft Office 97 SR-1:

                  Minimum
   File Name      SR-1 Version*    Size in Bytes*
   ----------------------------------------------

   Mso97.dll      8.0.4202         3,782,416
   Excel.exe      8.0a or higher   5,604,624
   Winword.exe    8.0              5,324,560
   Outllib.dll    8.02 or higher   4,375,312
   Msaccess.exe   8.0.4122         3,016,976
   Powerpnt.exe   8.0              3,499,792

   * Note that file versions may be later or file sizes may be higher than those shown
     here due to maintenance releases, recalculation patches, or other
     interim upgrades. If the version of a file is earlier than that shown
     above, the SR-2 Patch cannot proceed.

You can check the versions of your files by following these steps for each
file listed above:

1. On the Start menu, point to Find, and click Files Or Folders.

2. In the Named box, type the name of the file for which you want
   to search. In the Look In box, click to select My Computer. Then, click
   Find Now.

   The Find dialog box should locate a single copy of the file on your
   computer.

3. Right-click the file. On the shortcut menu, click Properties.

4. You can check the file size by looking at the Size in the General tab.
   You can also check the file version by looking at the File Version in
   the Version tab.

5. Click Cancel.

If the version of the file from step 4 is earlier than that shown above, or
if the size of the file is less than that shown above, the file must be
deleted. To do so, follow these steps:

1. Right-click the file. On the shortcut menu, click Delete.

2. Click Yes to send the file to the Recycle Bin.

If the version of the file is later than or equal to that shown above,
and if the size of the file is greater than or equal to that shown above,
the file need not be deleted.

Verify the Mso97.dll Key in Your Registry
-----------------------------------------

If the mso97.dll key in your registry refers to an incorrect location for
Mso97.dll, the SR-2 Patch will fail. To correct this problem, follow these
steps:

1. On the Start menu, point to Find, and click Files Or Folders.

2. In the Named box, type "Mso97.dll" (without quotation marks). In
   the Look In list, select My Computer. Then, click Find Now.

3. Write down the path shown for the Mso97.dll file. For example:

      C:\Program Files\Microsoft Office\Office

4. Close the Find dialog box.

5. On the Start menu, click Run. In the Open box, type "regedit"
   (without quotation marks). Click OK.

6. In the registry tree, click the plus sign (+) to the left of the
   following items, in order:

      HKEY_LOCAL_MACHINE
      Software
      Microsoft
      Shared Tools

   Then, click the "mso97.dll" folder.

7. In the right pane, click Path. On the Edit menu, click Modify. In the
   Value Data box, type the path you wrote down in step 3. Add
   "\Mso97.dll" (without quotation marks) to the end of the path, so that
   it resembles the following:

      C:\Program Files\Microsoft Office\Office\Mso97.dll

8. Click OK. Then, click Exit on the Registry menu.

Reinstall Microsoft Office 97 SR-1
----------------------------------

If, while following the previous steps, you removed any files from your
computer, you must now reinstall Microsoft Office 97 SR-1. The required
method depends on how you originally installed Microsoft Office 97:

 - If you originally installed Microsoft Office 97 and then ran the SR-1
   Patch, you will need to reinstall Microsoft Office 97, and then rerun
   the SR-1 Patch.

   To reinstall Microsoft Office 97:

    1. On the Start menu, point to Settings, and click Control Panel.
       Double-click Add/Remove Programs. Select Microsoft Office 97, and
       click Add/Remove.

    2. In the Microsoft Office 97 Setup dialog box, click Reinstall. You
       may be prompted for your Microsoft Office CD or floppy disks.

    3. Once Microsoft Office 97 has been reinstalled, run the SR-1
       Patch. If you no longer have a copy of the SR-1 Patch on your
       computer or on a CD, you may download the SR-1 Patch from the
       following address:

         http://officeupdate.microsoft.com/articles/sr1fact.htm

 - If you originally installed the Microsoft Office 97 SR-1 Enterprise
   Update, simply reinstall:

    1. On the Start menu, point to Settings, and click Control Panel.
       Double-click Add/Remove Programs. Select Microsoft Office 97, and
       click Add/Remove.

    2. In the Microsoft Office 97 Setup dialog box, click Reinstall. You
       may be prompted for your Microsoft Office CD or floppy disks.

Run the SR-2 Patch
------------------

Now that you have deleted all duplicate files, have deleted all files whose
versions are earlier than in SR-1, have checked your Mso97.dll registry key,
and have reinstalled Microsoft Office 97 SR-1, you are ready to run the
SR-2 Patch.

If All Else Fails
-----------------

If you have performed the steps above and the SR-2 Patch still does not
install, it is possible that your copy of the SR-2 Patch is invalid. To
re-download the SR-2 Patch, use your Web browser to go to the following
address:

   http://officeupdate.microsoft.com/articles/sr2fact.htm

NOTE: The file size of the downloaded SR-2 Patch should be 24,140,040
bytes.

Once you have re-downloaded the SR-2 Patch, try running it again.

MORE INFORMATION
================

When you run the SR-2 Patch, it checks the file versions of certain
critical files to make sure that you actually have Microsoft Office 97 SR-1
installed on your computer. If the version of any of the files is earlier
than that used in SR-1, the SR-2 Patch will not install.

This problem may occur if the version of any of the following files is
incorrect for any reason:

   Mso97.dll
   Excel.exe
   Winword.exe
   Outllib.dll
   Msaccess.exe
   Powerpnt.exe

The problem may also occur if the registry key that refers to Mso97.dll
refers to the incorrect location for the file.

When you run the SR-2 Patch, it creates a log file. The log file is called
97sr2_>#<.log, where >#< is a number (0, 1, 2, and so on), and is stored
in the same folder as your Microsoft Office files.

If the SR-2 Patch fails, the reason for the failure is recorded in this log
file. You can use this information to narrow down the cause of the problem;
this may help reduce the number of steps from above that you need to
perform.

   Text                             What Does it Mean?
   --------------------------------------------------------------------

   Excel is Office 97 base.         Excel.exe version is incorrect

   Word97 is Office 97 base.        Winword.exe version is incorrect

   Outlook is Office 97 base.       Outllib.dll version is incorrect

   Access is Office 97 base.        Msaccess.exe version is incorrect

   PowerPoint is Office 97 base.    Powerpnt.exe version is incorrect

   >Path<\MSO97.DLL is on the       Mso97.dll version is incorrect
   client machine but is less
   than sr1 level

   The file >path>\MSO97.DLL does   Mso97.dll key in registry refers to
   not exist                        incorrect path

In addition, the following text may appear in the log file when the SR-2
Patch fails:

   The SR2 patch will only operate when you have all the Office 97 apps
     upgraded to at least SR1
   Sr1 is not found in the user's machine
   Sr2 patch can not run without sr1 installed


 
0
gigo30Author Commented:
I ended up ordering the Enterprise Update free CD from Microsludge. The SR2 CD didn't work. As I surmised, the SR2 CD only had SR1 and SR2 files on it, it was not a full install.
0
ianBCommented:
Hi,
I am answering this question so it can be saved as a PAQ. I have refunded the points you used for the question.

Ian
Community Support @ Experts Exchange
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.