Microsoft KB Archive/172366

= ACC97: Microsoft Access 97 Enhancements in Service Release 1 =

Article ID: 172366

Article Last Modified on 7/20/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q172366



Novice: Requires knowledge of the user interface on single-user computers.



SUMMARY
This article lists the changes to Microsoft Access 97 in both Microsoft Access 97 Service Release 1 and Microsoft Office 97 Service Release 1, and it describes how you can receive the update.

NOTE: Stand-alone Microsoft Access 97 Service Release 1 is not currently available, but you can update your copy of Microsoft Access 97 to Service Release 1 by downloading Microsoft Office Service Release 1 at the Web address given in the "More Information" section. We will update this article when Stand-alone Microsoft Access 97 Service Release 1 becomes available.



How to Obtain Service Release 1
If you already have Microsoft Access 97, or Microsoft Office 97 Professional Edition, you can download Service Release 1 from Microsoft's Web site at:

http://office.microsoft.com/en-us/downloads

Microsoft Access 97 Service Release 1 contains updated files as well as the new Snapshot feature.

Snapshot and Snapshot Viewer
Microsoft Snapshot enables you to view a report without having Microsoft Access 97 or the run-time version of Microsoft Access 97 on your computer. You see the report as it would appear in print preview in Microsoft Access.

Microsoft Snapshot allows you to save a static picture of a Microsoft Access 97 report in an external file format (*.snp). You can then make the report available to someone who does not have Microsoft Access 97. For example, you can send the report in e-mail or copy it to a person's hard drive. The person needs only the Microsoft Access Snapshot Viewer to be able to view the report.

Microsoft Access 97 Snapshot Viewer, Snapview.exe, enables you to view a Microsoft Access report that has been saved as a snapshot (*.snp). You can distribute the self-extracting file that installs Snapshot Viewer to anyone who has Microsoft Windows 95 or Microsoft Windows NT. The Snapshot Viewer enables you to view reports that have been exported to the new snapshot file format, which is available in Service Release 1.

If you obtained Microsoft Access 97 Service Release 1 on CD-ROM, Snapshot Viewer is located in the \ValuPack\Access subfolder on the CD-ROM. Snpvw80.exe is a self-extracting file that installs the Snapshot Viewer. Double-click the \ValuPack\Valupk8.hlp file on your CD-ROM for information about installing ValuPack features, including the Snapshot Viewer.

If you downloaded Microsoft Office 97 Service Release 1 from Microsoft's World Wide Web site, you automatically have the ability to export reports to snapshot file format. Snapshot Viewer, however, is a separate download. Search Microsoft's Web site for Snpvw80.exe, or go to Microsoft Office FreeStuff or Microsoft Office Developer's Forum.

For more information about report snapshots, please see the following article in the Microsoft Knowledge Base:

172348 ACC97: Report Snapshots and Microsoft Snapshot Viewer

Fixes in Service Release 1
The following issues have been addressed in Microsoft Access 97 Service Release 1:


 * Hungarian short date formats do not allow a trailing period.


 * "Automation Error" when opening a replica after making a module non-replicable in a Design Master database.

For details about this issue, please see the following article in the Microsoft Knowledge Base:

171207 ACC97: Removing Replicated Module Causes Automation Error


 * Replica becomes unusable when modules in the Design Master database are made replicable serially.

For details about this issue, please see the following article in the Microsoft Knowledge Base:

172162 ACC97: "Name conflicts..." Error When Opening Replica


 * Graph does not display correct data when report is opened from the Database window.

For details about this issue, please see the following article in the Microsoft Knowledge Base:

165836 ACC97: Graph 97 Chart Object Does Not Update Display Correctly


 * ActiveX control bound to OLE Object updates data incorrectly.


 * Duplicate rows appear in the MSysRelationships system table of a back-end database when the front-end is under source code control.

For details about this issue, please see the following article in the Microsoft Knowledge Base:

164238 ACC97: Duplicate Relationships Multiply in Back-End Database


 * Wizard objects or sample database objects found in database after conversion.

For details about this issue, please see the following article in the Microsoft Knowledge Base:

150099 ACC97: DB Contains Incorrect Objects After Upgrade to Access 97


 * High ANSI characters do not display properly on splash screen under Windows NT 4.0.


 * IPF in MSAccess.exe using Database Wizard on Windows NT 4.0 workstation running Run from Server install on a Novell 4.1x server.


 * Microsoft Jet database engine consumes disk space with temporary queries in an explicit transaction.


 * SELECT statement returns wrong result set when a table has multiple-field index in Japanese version of Microsoft Access.


 * Binary Large Objects (BLOBs) can be lost when synchronization errors are corrected in replicated databases.

For details about this issue, please see the following article in the Microsoft Knowledge Base:

172164 ACC97: Data in OLE Object or Memo Field Missing from Replica


 * Error "Table 'TMP%#MAU@' already exists" opening attached SQLBase table.

For details about this issue, please see the following article in the Microsoft Knowledge Base:

167849 ACC: 'TMP%#MAU' Error Generated When Opening Linked Table


 * Error "Out of Memory" when starting Microsoft Access on a computer that has 1 gigabyte (GB) or more of random access memory (RAM).

For details about this issue, please see the following article in the Microsoft Knowledge Base:

161255 ACC: "Out of Memory" Error Starting Microsoft Access

Additional query words: upgrade maintenance bug fix

Keywords: kbinfo kbusage KB172366

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.