Snapshot

[JohnLee]

Hi,

not sure if this is the right place to ask this question, but here goes anyway.

Is there a limit to the number of pages in a report that snapshot can export as an .snp file?

Where does snapshot put it's temporary files?

This is the message I get when running my code for a specific file:

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

I've got 20 GB of disc space free, so this doesn't make sense.

Any assistance would be most appreciated.

John

 

[pbaldy]

See if this helps:

http://support.microsoft.com/kb/226526

 

[JohnLee]

Hi,

Thanks for that, my problem is listed there, but unfortunately having checked all the causes suggested the problem still persists. I guess it's back to the drawing board.

John

 

[JohnLee]

Hi,

I thought I'd run a test of my code clearing out all the data from my reports [tables] and yes you've guessed it, it ran fine! All the snapshot reports were produced [allbeit with no data], so it would seem that the volume of data does have some significance.

So the next step is to see how much data the snapshot can handle before it falls over.

Just thought I's share that.

John

 

[gemma-the-husky]

perhaps theres some temporary file declared in tools options somewhere

do you have a partitioned hard disk, as the temp file will be somewhere buried in the C: drive i would think - so although you have a big disk, there may be insufficient space on that particular drive

 

[HiTechCoach]

Hi,

I thought I'd run a test of my code clearing out all the data from my reports [tables] and yes you've guessed it, it ran fine! All the snapshot reports were produced [allbeit with no data], so it would seem that the volume of data does have some significance.

So the next step is to see how much data the snapshot can handle before it falls over.

Just thought I's share that.

John

John,

If you preview the report with all the data you want, how many pages?

Also, what file name are you using when you print all the data?

 

[JohnLee]

Hi Gemma,

Thanks for your response, I visited the web site suggested by pbaldy and my error message was there, however from the information supplied by Microsoft this has nothing to do with disc space!! according to microsoft Run-time error 2024 has one of the following causes:

not specifying a file name

or

the file name supplied contains invalid characters

or

the path specified does not exist

The solutions are of course to address those issues. However from my perspective its a bit strange that the error message 2024 says there's not enough disk space for temporary work files, given the above causes.

I conducted tests on a computer that was not on a network, just in case there was something to do with being on a shared network, but when you get to over 100 pages in a report it starts to slow down and then when you get to over 200 pages Access stops responding.

So it would appear that there is a limit to the number of pages Access can output as a snapshot in a report.

John