Tag Archives: 1997

Shovelware Showcase – The Complete Reference Collection: 1998 Edition

This is a post covering the content included with The Complete Reference Collection: 1998 Edition CD-ROM by The Learning Company (TLC) as part of the Shovelware Showcase series.

Overview

The Complete Reference Collection: 1998 Edition is part of the Compton’s Home Library series of reference software. This edition is from 1997 and covers the forthcoming year 1998. There is only one item of software contained on the CD-ROM which retains the same name as the release. The software is a navigator/browser type of application which splits into 10 sections:

  • Encyclopedia
  • World Almanac
  • Dictionary
  • Thesaurus
  • Writer’s Handbook
  • World Atlas
  • Geographical Dictionary
  • Home Medical Guide
  • World History
  • Internet Dictionary

Packaging

Packaging consists of a standard size CD-ROM jewel case with a solid black tray. A full colour front booklet is included with 9 pages of content. The last page of the booklet advertises other titles The Complete Interactive Cookbook and Compton’s Interactive Encyclopedia. The rear inlay is single sided and lists the titles included with this compilation.

Identifiers

The rear inlay has identifiers of CRC2844BB and CRC8BB-BI.

The booklet has an identifier of CRC8BB-FI.

The CD-ROM has an identifier of CRC844BB-CD with a matrix ring of MR0242 CRC2844BB MPO IRL 2X.

Contents

The CD-ROM is filled 628 MB out of a possible 700MB.

The featured items of software are:

  • The Complete Reference Collection 1998

Software

Name Publisher Version Tested
The Complete Reference Collection 1998 The Learning Company 1.01I Yes

Images, Audio and Video

The disc contains various multimedia files which help ‘enhance’ the software.

There are 43 AVI files under the directory VIDEO.

There are 178 WAVE files under the directory SOUND of which all are mono.

The directory MONTAGE contains 9 AVI video files.

The directory BTNSND (Button Sound) contains 25 WAVE files of which all are mono.

The directory ANIMATIO contains 9 AVI video files.

Miscellaneous

The only unusual thing on the CD-ROM is a directory named EREG which contains a bitmap which shows an offer for the ZD Internet Magazine (see gallery below) – through multiple installations on different operating systems I have never had this display during or after installation.

Images

Add More Clip Art in Office 97 (Windows 10)

If you have managed to successfully install Microsoft Office 97 onto your Windows 10 computer, and have followed my previous guide on how to get the Clip Art Gallery working then you (like myself) probably felt a little deflated when you opened it up to find only a meagre 79 clips.

In this guide I will show you how to end up with over 3,000 clips for free, complimentary of Microsoft themselves without the requirement for any dodgy downloads or needing to manually catalogue each clip.

The Problem

The problem we are trying to fix in this guide is simple, not enough clips! And let’s be honest if you’ve got this far and gone to this much trouble to get Clip Art working under Windows 10 you’ll probably want all the clips you can get, right?

Assumptions/Prerequisites

The following assumptions are being made:

  • You are using either Windows 10 build 1809 or 1803
  • The version of Windows you are using is of 64-bit architecture
  • You have installed Office 97 and selected the Clip Gallery and Popular Clipart options
  • You have installed Office 97 with one or more applications enabled: Word, Excel, PowerPoint, Publisher
  • At time of installation you left the installation location to its default path of C:\Program Files (x86)\Microsoft Office
  • You have administrative rights over your PC
  • You have the original Office 97 Standard CD-ROM (or a disc image of the CD-ROM)

The Fix

These instructions should, once completed, change the behaviour of the Clip Gallery in all Microsoft Office programs that support Clip Art. We are simply using Microsoft Word as the default example.

  1. Open File Explorer by launching it from the task bar or by clicking Start and typing This PC
  2. Insert (or mount if using a disc image) the Office 97 Standard CD-ROM. Open the CD-ROM’s contents in Explorer by right clicking the CD-ROM device in This PC and then choosing Open from the context menu.
  3. Open the folder CLIPART. Using your keyboard and mouse, hold SHIFT and then left-click on the first folder (Bullets). While still holding the SHIFT key click on the last folder SCRBEANS.
  4. With these folders selected either press CTRL + C on your keyboard or right-click on a selected folder and choose Copy from the context-menu.
  5. Click on the Local Disk (C:) option from the left-hand pane in Explorer, then drill down the folder structure by opening Program Files (x86) and then Microsoft Office then Clipart. In a white space right-click and choose Paste from the context-menu.
  6. Explorer will then begin to calculate the amount of files it needs to copy. It will identify 80 duplicate files (which are the 79 clips you see already, plus 1 CAG file), choose the option Skip these files.
  7. You will then be asked to give Administrator Permission to complete the copy process. Tick the Do this for all current items checkbox and then click on the Continue button, you may be asked to enter the credentials of an administrator account.
  8. Explorer will now begin to copy the files across from the CD-ROM to your local disk drive. This process may take a few minutes depending on the speed of your hard disk drive and if you are using a CD-ROM or a disc image as the source for the copy.
  9. With the copy completes, open Microsoft Word 97. Open the Clip Gallery by choosing Insert then Picture and finally Clip Art from the menu bar.
  10. Don’t be disappointed, when you open up Clip Gallery it will still only show 79 items. However we now need to import the additional 4,000 clips in. Click on the Import Clips button.
  11. The Add clip art to Clip Gallery dialog box will then appear. Change set the Files of type drop-down to Clip Gallery Packages (should be last in the list) and then click the directory level up button (folder with an arrow pointing upwards) – you should now be in the Clipart folder.
  12. Open the folder OFFICE and select the only CAG file present. Click Open to load the file into Clip Gallery, you should then receive a message confirming the package has been added to the Clip Gallery and that you will need to quit and restart the Clip Gallery to view the new items.
  13. Click OK to dismiss the confirmation message. and then close the Clip Gallery by choosing the Close button. Re-open the Clip Gallery (Insert then Picture and finally Clip Art).
  14. You should now see that you have 2079 clips available under the Clip Art tab. You can add more content by clicking Import Clips and adding the CAG files found in the folders PHOTOS, POWERPNT and SCRBEANS (closing and re-opening Clip Gallery with each action). Under the Pictures tab you should have 144 items. The Sounds and Videos tabs will likely still show 0 items. You can increase this number by importing the CAG file under MMEDIA however you will find at the moment you are unable to preview or insert any of these items.

Summary

If you have followed the above steps you should now have just over 3,000 additional clips in your Clip Gallery. More clips could be added from later versions of Office if they have the .CAG file present, or from third party compilations.

What is nice is that because clip art uses mostly vector technology, the clips can scale to the large HD resolutions that we operate today without corruption or degradation of quality.

Although it is a shame that at the moment I cannot get the audio-clips or video-clips to operate – the 3,000 clips should certainly keep any one keen on a nostalgia trip happy for some time.

Explanation of Fault

Around the time that Office 97 was released, hard disks were still on the small size in comparison to today’s 100’s if not 1000’s of terabytes of storage. For this reason many items of computer software (including video games) would often keep a lot of their media assets (such as graphics, videos and sound files) on the CD-ROM, instead of copying the content to the local hard disk drive. This would mean that for some of these items of software to operate, or for the user to experience the full feature set of an application (such as Microsoft Office) they would need to keep the CD-ROM handy or in their CD-ROM drive during use.

Although when you consider that the content we have copied here only amounts to a measly 86.7 MB (on disk) – this could be considered a serious amount of free space lost for most computer users in 1997.

There really isn’t any further explanation needed as to why Office 97 included (by default) such a small amount of clips – it was simply a design choice to reflect the needs of users at the time.

Guide – Get Clip Art (Clip Gallery 3.0) for Office 97 Working with Windows 10

This guide will quickly explain how to get Microsoft Clip Gallery 3.0 (included with the Office 97 suite) working under Windows 10.

By following this guide you will be able to import clip-art items into your documents, spreadsheets, publications or presentations with any of the following Office 97 applications:

  • Word 97
  • PowerPoint 97
  • Excel 97
  • Publisher 97

The Problem

This guide addresses the following errors or problems you may be facing.

  • Error dialog: The Clip Gallery encountered an error. Try restarting Windows, or reinstalling Microsoft applications.
  • Error dialog: The Clip Gallery can not run because the database file has been marked read-only. Use File Manager or the Explorer to locate ARTGALRY.CAG, and remove the read-only file property.

  • Display issue: The clip gallery is empty, no clip art is available or visible for selection/insertion.

Assumptions/Prerequisites

The following assumptions are being made:

  • You are using either Windows 10 build 1809 or 1803
  • The version of Windows you are using is of 64-bit architecture
  • You have installed Office 97 and selected the Clip Gallery and Popular Clipart options
  • You have installed Office 97 with one or more applications enabled: Word, Excel, PowerPoint, Publisher
  • At time of installation you left the installation location to its default path of C:\Program Files (x86)\Microsoft Office
  • At time of installation you left the program group value to its default value of “Microsoft Office
  • You have administrative rights over your PC

The Fix

In this series of instructions we use Microsoft Word as the application to be used with Clip-Art. For other applications such as Excel, PowerPoint or Publisher please read their names instead of Word in this guide.

  1. Open File Explorer by launching it from the task bar or by clicking Start and typing This PC
  2. Click in the address bar and paste the following string:
    %appdata%\Microsoft\Windows\Start Menu\Programs\Microsoft Office
  3. Tap enter to go to the above location.
  4. Select Microsoft Word and right click, choose Properties from the context menu.
  5. With the Properties window open choose Compatibility and tick the option Run this program as an administrator under the Settings header
  6. Click OK to save changes.
  7. Run Microsoft Word by starting it from your Start Menu⚠ You may have to accept/dismiss a UAC/Administrator prompt when opening Microsoft Word ⚠
  8. With Microsoft Word running open the Clip Gallery by choosing InsertPictureClip Art…
  9. The Microsoft Clip Gallery 3.0 should now open with a selection of clips.

If the Clip Gallery is Empty

  1. Click on the Import Clips… button in the Microsoft Clip Gallery 3.0
  2. An Add clip art to Clip Gallery dialog will open
  3. Click the Look in: drop-down menu and change the option to Local Disk (C:)⚠ Your C: drive may have a name different to Local Disk, choose the disk that is assigned the letter C ⚠
  4. Open the folder Program Files (x86) and then Microsoft Office and then Clipart and finally Popular
  5. Press CTRL + A on your keyboard to select all the files in the folder and then click Open
  6. Clip Properties dialog window will now open. Tick Add all clips to the selected categories and then choose OK
  7. You will then see another dialog box The Clip Gallery Package has been added to Clip Gallery. You must quit and restart Clip Gallery to view the new package –click OK to dismiss this message
  8. Close the Microsoft Clip Gallery 3.0 window, and then re-open it from Word (InsertPictureClip Art…). The Clip Gallery should now show any clips you have imported.

Summary

If you have followed the above steps you should now be able to easily add in the clip-art that is included with your Office installation into documents, spreadsheets, presentations and publications.

By default the Office 97 installer only installs 79 Clip Art clips – no pictures, sounds or videos. If you have the Microsoft Office 97 Standard Edition CD-ROM available you can increase this number to over 4,000 clips easily by following this guide here.

Explanation of Fault

Although I am not affiliated with Microsoft in any way, I do have a good grasp on how their modern operating systems work and what issues these may pose to applications that are over 20 years old.

Modern Windows operating systems (starting with Vista through to 10, including 7, 8 and 8.1) implement a stricter security system to all operating systems to prevent the unauthorised installation of software, modification of system files or access to personal documents. Although this security system does help prevent unauthorised access from other individuals in your home or office, the main purpose of this security system is to prevent malware (such as viruses) to infect, corrupt or otherwise modify system files without your explicit approval.

When the Office 97 suite was implemented security was rather archaic, and UAC simply did not exist. When the Office 97 suite installs the applications, including the Clip Gallery and clips to your disk it places the files in areas that Windows considers by default “secure” locations. This means that when you try to open an application such as Word without elevating the application with an administrator prompt (such as UAC) it does not have security clearance to amend these files. By elevating the application you are granting that application (or process, in this case WINWORD.EXE) full security clearance to those protected locations.

The Clip Gallery uses a simple database file know as a CAG file (Clip Art Gallery Package file). This file is usually empty when it is installed, and needs to be populated. If the process, in this case WINWORD.EXE, does not have write access to this file (due to not being elevated) then the application will either throw a critical system error message or simply enter the Not Responding state.

What we do in this process is set the WINWORD.EXE process to always request to be elevated. Upon the next execution of the application we are prompted with a UAC Prompt to allow this elevation. From here the process can access the CAG file and modify it as necessary.

Although it is likely that an application as simple as WINWORD.EXE would not make any dangerous changes to system files, it is best practice to avoid constantly running the application with elevated privileges. However you will likely find that if you don’t elevate the process you will not be able to insert any further clip-art until you elevate WINWORD.EXE.

I could tell that it was likely a security permission issue that was causing this fault, however I did evidence my findings by using Sysinternals Process Monitor which confirmed that the WINWORD.EXE process was unable to open the CAG file for amendment.

Carling Premier – Cool Cuts (Carling)

Artist – Various artists, all original recordings
Release Year – 1997
Record Label –
Fastforward Music
Format – CD compilation
Promoting 
– Carling Premier lager
Theme – Cool eighties music

If I recall correctly I ended up with this particular CD as part of one of the many hauls I picked up in 2018. Sadly however I don’t remember which, for I ended up becoming quite swamped in the format this year and so many of these wonderful promotional CD’s sat under my bed gathering dust.

Luckily for all of us a kind Discogs contributor can shed some light in that this CD was given away with Carling Premier lager to promote their Unique Smooth Chill System. This unique system is explained in the short booklet included with the CD as being Smoother and Creamier.

As a compilation the selection here isn’t terrible, however a bit meagre with only 8 tracks; although they are all original recordings.

Tracklist

  1. Gary Numan – Cars (The Premier Mix)
  2. The Human League – Love Action (I Believe In Love)
  3. Heaven 17 – Temptation
  4. Spandau Ballet – Chant No1 (I Don’t Need This Pressure On)
  5. Re-Flex – The Politics of Dancing
  6. Tubeway Army – Are ‘Friends’ Electric?
  7. Culture Club – Time (Clock of the Heart)
  8. Scritti Politti – Wood Beez (Pray Like Aretha Franklin)

 

Gallery