disk space for temporary work files

G

Guest

I am using the DoCmd.OutputTo command in a loop statement to send reports as snapshots into various directories on my company network. The following line of code is taken directly from the Access Module

DoCmd.OutputTo acReport, "rptDailySummary", "SnapshotFormat(*.snp)", strHmDir, False, "

Note: strHmDir = //server/dirx/diry/file.sn

When the module runs the following error message appears
Run Time Error '2024
The report snapshot was not created because you don't have enough disk space for temporary work files

I have completed the disk cleanup utility on both the PC that is running the application and the server that contains the network directories

Has anyone ever run into this problem before and if so what is the solutio

Thank

Ale
 
B

Bryan Reich [MSFT]

Alex,
How much free space on the computer running the app, and how big is the
report?
--
Bryan Reich
Microsoft Office
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm


Alex said:
I am using the DoCmd.OutputTo command in a loop statement to send reports
as snapshots into various directories on my company network. The following
line of code is taken directly from the Access Module:
DoCmd.OutputTo acReport, "rptDailySummary", "SnapshotFormat(*.snp)", strHmDir, False, ""

Note: strHmDir = //server/dirx/diry/file.snp

When the module runs the following error message appears:
Run Time Error '2024'
The report snapshot was not created because you don't have enough disk
space for temporary work files.
I have completed the disk cleanup utility on both the PC that is running
the application and the server that contains the network directories.
 
S

Stephen Lebans

You need to learn how to search the MS KB here:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;kbhowto&sd=GN&ln
=EN-US&FR=0

Your error message would have returned this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;226526&Product=a
cc
ACC: Error Message Using OutputTo to Output a Report to Another Format


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Alex said:
I am using the DoCmd.OutputTo command in a loop statement to send
reports as snapshots into various directories on my company network.
The following line of code is taken directly from the Access Module:
DoCmd.OutputTo acReport, "rptDailySummary", "SnapshotFormat(*.snp)", strHmDir, False, ""

Note: strHmDir = //server/dirx/diry/file.snp

When the module runs the following error message appears:
Run Time Error '2024'
The report snapshot was not created because you don't have enough disk
space for temporary work files.
I have completed the disk cleanup utility on both the PC that is
running the application and the server that contains the network
directories.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top