ACC97: Microsoft Access 97 Enhancements in Service Release 1

ID: Q172366


The information in this article applies to:
  • Microsoft Access 97


SUMMARY

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

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.


MORE INFORMATION

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://officeupdate.microsoft.com/Articles/sr1fact.htm



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:

Q172348 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:

Q171207 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:

Q172162 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:

Q165836 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:

Q164238 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:

Q150099 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:

Q172164 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:

Q167849 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:

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

Additional query words: upgrade maintenance bug fix

Keywords : kbusage GnlOthr
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbinfo


Last Reviewed: April 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.