Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro outputs to snapshot - error: The report snapshot was not created

Status
Not open for further replies.
Feb 14, 2005
31
0
0
US
I've google this problem and found few questions being asked and even fewer answers.
Here is the closest thing:
My issue: I have a user with Access 2003 that wants to use a macro to export his report to a snapshot file (.snp) out to a mapped network drive (G:). When he does he gets the error: "The report snapshot was not created because you don't have enough free disk space for temporary work files. To fix this, free up disk space..."
[ul]
[li]The mapped drive he is sending it to is his "home" drive where he keeps all his files, and it has 400+ Gb free.[/li]
[li]If we manually export it to the mapped drive ("File" --> "Export" --> FileType: Snapshot) then the snapshot file is successfully created.[/li]
[li]The macro will work in creating the snapshot if we send it too his local C: Drive.[/li]
[/ul]
It almost seems like the macro function is using some other credentials when it tries to create the file on the mapped network drive.

Anyone have any ideas on this problem? Any help would be greatly appreciated.

Eddie
 
-Solved-

I took another look at the macro and found a typo. The destination path was pointing to a non-existant sub-directory.

Where's the smiley for embarrassment? LOL


Eddie
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top