Report snapshot woes: runtime error 2024

[Christine Pearc]

I'm receiving Run-time error ‘2024’ - The report snapshot was not recreated because you don’t have enough free disk space for temporary work files.

I've looked at all the threads from people who've had the same problem and tried the recommendations, but I still get the error on both these versions of the code.

DoCmd.OutputTo acOutputReport, "rpt CAR form", acFormatSNP, "M:\Public\CAS", True

DoCmd.OutputTo acOutputReport, "rpt CAR form", "SnapshotFormat(*.snp)", "M:\Public\CAS", True

BTW, I'm saving to a network drive, if that makes a difference.

Can someone help please?

Thanks,
Christine

 

[jamesmor]

not really sure I can help. but here goes.

first thing I'd do is try to have it be created locally. If you still get the same error, you might look at your database size, it might be blowing up to huge proportions for some reason. maybe decompile it, then do a compact and repair

 

[Christine Pearc]

Thanks for your offer to help, James. I tried creating and saving the report locally (to my C drive, which has lots of space), compiled, compacted and repaired, and tried sending other reports (thinking perhaps one was corrupt) - all to no avail.

Does anyone else have any suggestions? This is beginning to cause a big headache!

Christine