?
Solved

Acc97 OutputTo Snapshot .snp Format

Posted on 2001-08-17
10
Medium Priority
?
354 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 58
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 58
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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 58

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 58
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

777 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