Problem with OutputTo Snapshot

[Rob]

I am randomly getting the following message when using the OutputTo
command...

"The report snapshot was not created because you don't have enough free disk
space for temporary
work files"

I have looked at the knowledge base article and do not think it has anything
to do with those reasons.

The program has been working well until recently. The points at which it
stops creating the snapshots is random. (It creates a series of snapshots
in sequence.)

The files are created on a "local" drive.
The program is run by an administrator.
The folder does exist.
There is nothing wrong with the file name (no special characters).
There is plenty of disk space (in general).

Does anyone know the definition of "enough free disk space for temporary
work files". Does this have to do with virtual memory ?

Thanks !

 

[Linq Adams via AccessMonster.com]

(It creates a series of snapshots in sequence.)

This is just a guess, but when printing a series of reports in sequence an
app sometimes fails because the printer buffer becomes full. In a similar
manner, your available disk space may, in fact, be exhausted as a number of
snapshots are created more or less simultaneously. In the print situation
this can be overcome by using

DoEvents

between the printing of each report, which returns control to Windows and
allows one job to be completed before staring the next. It might be
worthwhile to do this between the creation of each snapshot.

 

[Rob]

Thanks, but we are not actually printing them... there is code in the loop
that emails them though...

 

[Linq Adams via AccessMonster.com]

I know you're not printing them! The point is that you may be running out of
memory because Access doesn't create one snapshot, then create another one,
and so forth. It starts creating one and then, before that one is complete,
starts creating another one, on down the line.

DoEvents

placed between the creation of each snapshot, should allow one to be created
and the memory released before Access begins to create the next one.

 

[Rob]

Thanks again.., I tried that and still no dice. This is so frustrating...
It has worked fine for months, now all of the sudden it just stops randomly.

 

[Paolo]

Hi Rob,
delete all the garbage in the windows temp directory and the temp directory
in your profile and I'm pretty sure everything will work fine again. Those
directories are used as temporary directory by all the program that need
temporary space but if you never clean the disk they reach the max capacity
and no more temp files could be created.

HTH

 

[Rob]

Thanks, but we just tried this as well, no relief...

 

[MAJICMnt]

I am having the exact same problem. It seems random. I only get it at some
times, but not others. It is very frustrating.

 

[MAJICMnt]

I think i just figured it out. Do you have the file name exporting with any
invalid characters? For example, i was exporting with the filename from
field1. Field1 had the following entries.

Annual
PreProduction
Commerce/Business
Individual/Retail

The last two would error, but the first two would not. I thought it was
random, but figured it was the '/' which we all know can't be a filename.