Export report - Filename length limitation?

P

PK

Greetings!

I am exporting a report programatically:
DoCmd.OutputTo acReport, [ReportName], "SnapshotFormat(*.snp)", "", True,
"", 0

....and seem to be bumping into a limit on the filename length? (126 total
characters works, 127 total characters does NOT work - error below)

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

Is this publised anywhere? Any work-arounds or tips?

TIA for any help!
 
D

David Lloyd

The following KB article may be a useful reference.

http://support.microsoft.com/default.aspx?scid=kb;en-us;226526

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Greetings!

I am exporting a report programatically:
DoCmd.OutputTo acReport, [ReportName], "SnapshotFormat(*.snp)", "", True,
"", 0

....and seem to be bumping into a limit on the filename length? (126 total
characters works, 127 total characters does NOT work - error below)

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

Is this publised anywhere? Any work-arounds or tips?

TIA for any help!
 
P

PK

I had seen that one.

Sorry, I should have been more specific:
1) There is plenty of space on the drive.
2) The path being saved to contains no illegal characters
3) The condition (works vs doesnt work) can be easily reproduced by
shortening the path by a few characters.
 
D

David Lloyd

Maybe you can post the name and path you are using. The sample code you
posted does not show the path. If that is where the problem is, then seeing
this part of the OutputTo method would be helpful.

I completed a test with a path length of 176 characters without error.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I had seen that one.

Sorry, I should have been more specific:
1) There is plenty of space on the drive.
2) The path being saved to contains no illegal characters
3) The condition (works vs doesnt work) can be easily reproduced by
shortening the path by a few characters.
 
P

PK

Sorry I didnt respond sooner - was traveling yesterday!

Does not work:
C:\Documents and Settings\PaulK1\Desktop\TEST
OUTPUT\1234567890\1234567890\1234567890\1234567890\1234567890

Works:
C:\Documents and Settings\PaulK1\Desktop\TEST
OUTPUT\1234567890\1234567890\1234567890\1234567890\123456789



David Lloyd said:
Maybe you can post the name and path you are using. The sample code you
posted does not show the path. If that is where the problem is, then seeing
this part of the OutputTo method would be helpful.

I completed a test with a path length of 176 characters without error.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I had seen that one.

Sorry, I should have been more specific:
1) There is plenty of space on the drive.
2) The path being saved to contains no illegal characters
3) The condition (works vs doesnt work) can be easily reproduced by
shortening the path by a few characters.


David Lloyd said:
The following KB article may be a useful reference.

http://support.microsoft.com/default.aspx?scid=kb;en-us;226526

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or
warranties.


Greetings!

I am exporting a report programatically:
DoCmd.OutputTo acReport, [ReportName], "SnapshotFormat(*.snp)", "", True,
"", 0

....and seem to be bumping into a limit on the filename length? (126
total
characters works, 127 total characters does NOT work - error below)

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

Is this publised anywhere? Any work-arounds or tips?

TIA for any help!
Click to expand...
Click to expand...
 
P

PK

.... and the report name is:

One Page Report.snp





David Lloyd said:
Maybe you can post the name and path you are using. The sample code you
posted does not show the path. If that is where the problem is, then seeing
this part of the OutputTo method would be helpful.

I completed a test with a path length of 176 characters without error.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I had seen that one.

Sorry, I should have been more specific:
1) There is plenty of space on the drive.
2) The path being saved to contains no illegal characters
3) The condition (works vs doesnt work) can be easily reproduced by
shortening the path by a few characters.


David Lloyd said:
The following KB article may be a useful reference.

http://support.microsoft.com/default.aspx?scid=kb;en-us;226526

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or
warranties.


Greetings!

I am exporting a report programatically:
DoCmd.OutputTo acReport, [ReportName], "SnapshotFormat(*.snp)", "", True,
"", 0

....and seem to be bumping into a limit on the filename length? (126
total
characters works, 127 total characters does NOT work - error below)

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

Is this publised anywhere? Any work-arounds or tips?

TIA for any help!
Click to expand...
Click to expand...
 
P

PK

Here - let me rephrase this in a simpler way:

This works:
DoCmd.OutputTo acReport, "One Page Report", "SnapshotFormat(*.snp)",
"C:\Documents and Settings\PAULK1\Desktop\TEST
OUTPUT\1234567890\1234567890\1234567890\1234567890\123456789\One Page
Report.snp", False, "", 0

This does not work:
DoCmd.OutputTo acReport, "One Page Report", "SnapshotFormat(*.snp)",
"C:\Documents and Settings\PAULK1\Desktop\TEST
OUTPUT\1234567890\1234567890\1234567890\1234567890\1234567890\One Page
Report.snp", False, "", 0


The following 2 directories exist:
C:\Documents and Settings\PAULK1\Desktop\TEST
OUTPUT\1234567890\1234567890\1234567890\1234567890\123456789

and

C:\Documents and Settings\PAULK1\Desktop\TEST
OUTPUT\1234567890\1234567890\1234567890\1234567890\1234567890


Thanks again for the help!



David Lloyd said:
Maybe you can post the name and path you are using. The sample code you
posted does not show the path. If that is where the problem is, then seeing
this part of the OutputTo method would be helpful.

I completed a test with a path length of 176 characters without error.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I had seen that one.

Sorry, I should have been more specific:
1) There is plenty of space on the drive.
2) The path being saved to contains no illegal characters
3) The condition (works vs doesnt work) can be easily reproduced by
shortening the path by a few characters.


David Lloyd said:
The following KB article may be a useful reference.

http://support.microsoft.com/default.aspx?scid=kb;en-us;226526

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or
warranties.


Greetings!

I am exporting a report programatically:
DoCmd.OutputTo acReport, [ReportName], "SnapshotFormat(*.snp)", "", True,
"", 0

....and seem to be bumping into a limit on the filename length? (126
total
characters works, 127 total characters does NOT work - error below)

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

Is this publised anywhere? Any work-arounds or tips?

TIA for any help!
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error on OutputTo 1
Report to Snapshot Export Error? 4
User defined export file name 5
How to move to new Policy in Loop if Report is Null 1
Export Access report to a folder 0
disk space for temporary work files 2
Exporting Report To Excel 0
Printing differnt versions of a report 1

Top