Exporting Reports in Snapshot format

[Kyle Hunter]

I designed a database in Microsoft Access 2002 that has
an exporting issue that I wanted to address. After
extensive testing, I realized that when exporting a
report in the snapshot viewer format there is a size
limitation on a Novell File System (NFS). I tried to
export a number of different sized reports to a NFS and
kept receiving an error saying, "The report snapshot was
not created because there is not enough free disk space
for temporary work files." I verified that the path and
each file name had only alpha characters and underscores
without any spaces, that there weren't any rights issues
and attempted the export in both a macro and using
Microsoft Visual Basic (MVB). I also turned off File
Caching and File Commit and still had no luck. However,
when I exported the reports in the snapshot viewer format
running both the macro and the MVB on a NTFS it worked in
both instances, proving that there is a size limitation
when exporting a report in the snapshot viewer format on
a NFS. If anyone has a solution to my problem please feel
free to contact me.

Sincerely,

Kyle Hunter
Bridge Division
Texas Department of Transportation
(512) 416-3327
Correct e-mail is e-mail above without NOSPAM

 

[Keith]

Kyle
You say their is no rights issues - how about file space
assigned to the user. It may be possible to write to the
destination NFS directory, but your file allocation may
be too small for the temporary files to be created. Try
checking that first.

If that fails, the alternative would be to create the
snapshot file on the local workstation and then move it
using the VB file manipulation commands. Theat would
allow you to create on one system and copy to the other.