?
Solved

Acc97 OutputTo Snapshot .snp Format

Posted on 2001-08-17
10
Medium Priority
?
365 Views
Last Modified: 2008-02-01
Running Windows Professional 2000 with Office 2000.  Have Access 2000 and Access 97.  Under Access 2000 Reports can be saved as type .snp and can be Output to acFormatSNP.  Under Access 97 Reports can not be saved as type .snp or Output to acFormatSNP.

Is there a Snapshot module that can be loaded for Access 97 to create .snp output.  All documentation identify the solution is to upgrade to Office 97, SR 1, but this is not an option.
0
Comment
Question by:JerryPope
  • 4
  • 4
  • 2
10 Comments
 
LVL 14

Expert Comment

by:mgrattan
ID: 6398780
It's downloadable from Microsoft's web site.  Just a sec and I'll post the link.
0
 
LVL 59
ID: 6398782
You need SR-1 installed.  See the following MSKB article:

http://support.microsoft.com/support/kb/articles/Q172/3/48.asp

Jim.
0
 
LVL 59
ID: 6398787
Well Mike that had to be just a few seconds appart<g>.  Your post wasn't there before I typed the reply.

Jim.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 14

Expert Comment

by:mgrattan
ID: 6398790
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 6398793
Hi Jim.  I think anything posted within two minutes of the last posting can be considered "simultaneous".
0
 

Author Comment

by:JerryPope
ID: 6399003
Hello Jim
    Did not find the SR-1 for Access 97 at the Link address.  How would I search, "Access 97 SR-1"?

Hello Mike
    The link address points to the SnapShot Viewer.  I need the module that "Creates" the .snp output from Access 97.
0
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 800 total points
ID: 6400476
If you read down the article a bit, the link for the Office Download area:

http://www.microsoft.com/office/downloads/default.htm 

is under the "More Information" paragraph.

Jim.
0
 
LVL 59
ID: 6400481
As an addendum, after that page comes up, click on "Office Updates" and the top of the page.  A new page will popup where you can indicate the product and the release.  All files available will then be listed.

Jim.
0
 

Author Comment

by:JerryPope
ID: 6401376
Thanks Jim .. The Office 97 SR 1 must be downloaded, and updated even though Office 2000 is installed.  I kept looking for Access 97 SR1.
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 6407108
Jerry,

Also, please note that the snapshot viewer provides the capability to view AND create snapshot files.  It also comes with an ActiveX control which can be embedded in an Access form (or even a VB form) for viewing the snapshots from within your own applications.

Regards,
Mike
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question