How can I setup snapshot files on my server for downloading?

[rod_skeeter]

I am emitting snapshot reports to a folder and giving them the .snp
extensions. I then make the file available to the user for downloading via
our website. When the browser clicks on the selected file to download, we
get the message to OPEN or SAVE.

The problem is when the .snp file is SAVED/downloaded, it comes across as
..mdb file and not Snapshot. The file itself will not open as a database file
(i.e. .mdb). When we change the extension however to what it should be
(.snp) it opens and looks fine.

Why is the extension getting changed and how can we correct this?

Thanks for any assistance.

 

[Arvin Meyer [MVP]]

Check the file association with the snp extension.

Windows Explorer
Tools
Folder Options
File Types
scroll to SNP

then check what it opens. Under no condition should the file extension be
mdb.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[rod_skeeter]

I checked as you had indicated and it was associated with Snapshot. When I
clicked on it and opened it up to see the details, it said that it opens with
MS Access Snapshot Viewer.

Could it be a setting with the server?

Thanks for the response and assistance.

Kindest Regards.

 

[Tom Wickerath]

Hi Rod,

Very strange if something is actually causing the file extension to be
changed. Here is an MSDN article that might be helpful for you:

http://msdn.microsoft.com/library/d...2000/html/acrefAccessAboutReportSnapshots.asp

Check out the section titled "Using report snapshots on the World Wide Web".


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I checked as you had indicated and it was associated with Snapshot. When I
clicked on it and opened it up to see the details, it said that it opens with
MS Access Snapshot Viewer.

Could it be a setting with the server?

Thanks for the response and assistance.

Kindest Regards.

 

[Arvin Meyer [MVP]]

If all the machines try to open the file as an mdb, it may be something on
the server. I'd ask the Admin to check the server directly and see what
happens. I'd also check the registry [Start ... Run] then type: Regedit

From the Edit menu, choose: Find then type .snp and search your way through
the files. Several of the Keys are named DefaultExtension. Make sure they
are snp instead of mdb.

Also check to see if the AV program may associate snp with Access (mdb).

If you can't come up with any other solution, you may want to work around
this by printing to a PDF driver. There are a number of free ones out there,
but my personal favorite is Win2PDF which costs a small fee (less than 15%
of the cost of Adobe Acrobat). If you'd like to try a free one first, try
CutePDF. Also Stephen Lebans has built a beautiful application which outputs
to PDF directly within Access:

http://www.lebans.com/reporttopdf.htm

The next version of Access will include an export to PDF function in both
SendObject and OutputTo.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access