<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<TITLE>Snapshot Viewer</TITLE>
<META content="MSHTML 5.50.4807.2300" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=180291714-02062003><FONT face=Arial color=#0000ff size=2>I have
Access 97 installed on another machine, and all works fine, including the code
to create and email the snapshot,</FONT></SPAN></DIV>
<DIV><SPAN class=180291714-02062003><FONT face=Arial color=#0000ff size=2>it
appears to be the combination of Access 97/2000 and Windows 2000
that prevents Access 97 from creating snapshots,</FONT></SPAN></DIV>
<DIV><SPAN class=180291714-02062003><FONT face=Arial color=#0000ff
size=2>whether from a menu or code.</FONT></SPAN></DIV>
<DIV><SPAN class=180291714-02062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=180291714-02062003><FONT face=Arial color=#0000ff size=2>Thank
you for your help.</FONT></SPAN></DIV>
<DIV><SPAN class=180291714-02062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=180291714-02062003><FONT face=Arial color=#0000ff
size=2>Tony.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> John Colby
[mailto:jcolby@colbyconsulting.com]<BR><B>Sent:</B> 02 June 2003
15:09<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Snapshot Viewer<BR><BR></FONT></DIV>
<DIV><SPAN class=575210714-02062003><FONT face=Arial color=#0000ff
size=2>Ahhh...</FONT></SPAN></DIV>
<DIV><SPAN class=575210714-02062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=575210714-02062003><FONT face=Arial color=#0000ff size=2>I'm
afraid I can't help you there. I do know it is in a different place in
the menu but I no longer even have A97 installed on my system so I can't
help. Someone else will though, I'm sure.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Yeatman,
Tony<BR><B>Sent:</B> Monday, June 02, 2003 9:58 AM<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE: [AccessD] Snapshot
Viewer<BR><BR></FONT></DIV>
<DIV><SPAN class=505035513-02062003><FONT face=Arial color=#0000ff
size=2>Sorry, I am not explaining myself properly.</FONT></SPAN></DIV>
<DIV><SPAN class=505035513-02062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=505035513-02062003><FONT face=Arial color=#0000ff
size=2>When viewing an Access Report, and selecting "Save as/Export", the
list of available options does not include Snapshot.</FONT></SPAN></DIV>
<DIV><SPAN class=505035513-02062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=505035513-02062003><FONT face=Arial color=#0000ff size=2>So
it is the creating of the Snapshot that I am having problems
with.</FONT></SPAN></DIV>
<DIV><SPAN class=505035513-02062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=505035513-02062003><FONT face=Arial color=#0000ff
size=2>Regards</FONT></SPAN></DIV>
<DIV><SPAN class=505035513-02062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=505035513-02062003><FONT face=Arial color=#0000ff
size=2>Tony.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> John Colby
[mailto:jcolby@colbyconsulting.com]<BR><B>Sent:</B> 02 June 2003
14:47<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE:
[AccessD] Snapshot Viewer<BR><BR></FONT></DIV>
<DIV><SPAN class=141194313-02062003><FONT face=Arial color=#0000ff
size=2>Snapshot viewer from A97 is not built into the menu anywhere.
If I'm not mistaken, in A97 it has to be run from a desktop shortcut,
or have the .snp extension bound to that program so that the user just
loads the viewer when they try to open a snapshot. Snapshots after
all are files which can be mailed to someone that doesn't even have Access
installed. Send them the viewer and they can read your snapshot
reports. A2K simply added a menu item that opens the viewer from
inside Access.</FONT></SPAN></DIV>
<P><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of
</B>Yeatman, Tony<BR><B>Sent:</B> Monday, June 02, 2003 9:40
AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B> RE:
[AccessD] Snapshot Viewer<BR><BR></FONT></DIV>
<DIV><SPAN class=065023813-02062003><FONT face=Arial color=#0000ff
size=2>Thank you John for the link.</FONT></SPAN></DIV>
<DIV><SPAN class=065023813-02062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=065023813-02062003><FONT face=Arial color=#0000ff
size=2>Snapshot Viewer is as already installed, previously it was
version 9, so I installed the Version 8 on your site, with the same
result.</FONT></SPAN></DIV>
<DIV><SPAN class=065023813-02062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=065023813-02062003></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> John Colby
[mailto:jcolby@colbyconsulting.com]<BR><B>Sent:</B> 02 June 2003
13:17<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
RE: [AccessD] Snapshot Viewer<BR><BR></FONT></DIV>
<DIV><SPAN class=184341412-02062003><FONT face=Arial color=#0000ff
size=2>Snapshot viewer was not built-in for A97. It is an
available for A97 however and can be downloaded from my site <SPAN
class=184341412-02062003><FONT face=Arial color=#0000ff size=2><A
href="http://www.colbyconsulting.com/">www.colbyconsulting.com</A> </FONT></SPAN>by
clicking useful files and looking at the bottom of the list of
files.</FONT></SPAN></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>John W. Colby<BR>www.colbyconsulting.com</FONT>
</DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of
</B>Yeatman, Tony<BR><B>Sent:</B> Monday, June 02, 2003 7:53
AM<BR><B>To:</B> 'accessd@databaseadvisors.com'<BR><B>Subject:</B>
[AccessD] Snapshot Viewer<BR><BR></FONT></DIV>
<P><FONT size=2>I have Access 97, and Access 2000 installed on the
same machine, with</FONT> <BR><FONT size=2>Windows 2000.</FONT> </P>
<P><FONT size=2>The database I have written is in 97, even though
snapshot viewer</FONT> <BR><FONT size=2>is installed and can be
viewed/used from Access 2000, it cannot be used</FONT> <BR><FONT
size=2>from Access 97, not even manually. It is not listed as an
option.</FONT> </P>
<P><FONT size=2>Has anybody seen this problem ? or know of some
possible solutions.</FONT> </P>
<P><FONT size=2>Thank you in advance for any help you can
give.</FONT> </P>
<P><FONT size=2>Tony.</FONT> </P><CODE><FONT
size=3><BR><BR>*************************************************************************<BR>The
information in this internet E-mail is confidential and is intended
<BR>solely for the addressee. Access, copying or re-use of
information in it <BR>by anyone else is unauthorized. Any views or
opinions presented are <BR>solely those of the author and do not
necessarily represent those of<BR>Credit Lyonnais or any of its
affiliates. The information contained herein<BR>is recorded for
business purposes and use of services is monitored to<BR>protect
both the company and its individual users. If you are not the
<BR>intended recipient please contact
postmaster@creditlyonnais.co.uk<BR>*************************************************************************<BR></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></FONT></CODE></BODY></HTML>