Creating Snapshots - Destinations Path length Limit?

[Bob Darlington]

I'm using Access 2002 to create a snapshot using:
DoCmd.OutputTo acOutputReport, strReport, "SnapshotFormat(*.snp)",
strSnapshotFile
It works fine for the following path for strSnapshotFile:
\\server\dpcman\Tenant Statements\091123\301 Coronation Drive, Milton\Carbon
Energy Limited\Tax Invoice and Statement.snp
but generates an error 2024 ("The report snapshot was not created because
you don't have enough free
diskspace for temporary work files" ) for this one:
\\server\dpcman\Tenant Statements\091123\301 Coronation Drive, Milton\Clough
Projects Pty Limited\Tax Invoice and Statement.snp
The lengths of the paths are 121 and 127 characters respectively.
Does size matter (in this context)?
If so I can't seem to find a reference in the help file.
And I can't see any invalid characters in the path (as per the KB article on
the subject of 2024.
--
Bob Darlington
Brisbane

[Tom van Stiphout]

On Mon, 23 Nov 2009 21:06:45 +1000, "Bob Darlington"
<b...@notheredpcman.com.au> wrote:

The message does not speak about disk space on the server, but on your
workstation. Open a command window and type:
SET
Find the entry for TEMP and see what it points to. Make sure you have
enough disk space on that drive.

If you suspect filename length, as a test write it to the root of that
drive.

-Tom.
Microsoft Access MVP

[Bob Darlington]

Thanks for the reply Tom.
There's plenty of spare disk space (250GB Free);
I created a file name with 132 char to test in the TEMP folder and it
accepted it OK.

--
Bob Darlington
Brisbane
"Tom van Stiphout" <tom7744...@cox.net> wrote in message
news:8g6lg5llih58senfe...@4ax.com...

[Tony Toews [MVP]]

"Bob Darlington" <b...@notheredpcman.com.au> wrote:

>I'm using Access 2002 to create a snapshot using:
>DoCmd.OutputTo acOutputReport, strReport, "SnapshotFormat(*.snp)",
>strSnapshotFile
>It works fine for the following path for strSnapshotFile:
>\\server\dpcman\Tenant Statements\091123\301 Coronation Drive, Milton\Carbon
>Energy Limited\Tax Invoice and Statement.snp
>but generates an error 2024 ("The report snapshot was not created because
>you don't have enough free
>diskspace for temporary work files" ) for this one:
>\\server\dpcman\Tenant Statements\091123\301 Coronation Drive, Milton\Clough
>Projects Pty Limited\Tax Invoice and Statement.snp
>The lengths of the paths are 121 and 127 characters respectively.
>Does size matter (in this context)?

Maybe dpcman is a share a long way down from the root of the drive. That is on the
server hard drive it is

D:\A long folder name\Another long folder name\Another long folder name\.....(insert
lots more here)... \Tenant Statements\091123\301 Coronation Drive, Milton\Clough

>Projects Pty Limited\Tax Invoice and Statement.snp

Or maybe you're on a non Windows server that has a shorter path?

Just guessing though.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

[Bob Darlington]

Tony,
Thanks for the reply.
The UNC path (\\server\dpcman) translates to 'c:\program files\dpc manager
10' on my development PC (where I'm having
the problem.
But I have the same problem if I substitute 'c:\ ....' etc in the code, so I
gues its not UNC related.
Is there a documented limit on the length of path names or the number of
levels?
--
Bob Darlington
Brisbane
"Tony Toews [MVP]" <tto...@telusplanet.net> wrote in message
news:9dgog5572mepeehec...@4ax.com...

[Tony Toews [MVP]]

"Bob Darlington" <b...@notheredpcman.com.au> wrote:

>Thanks for the reply.
>The UNC path (\\server\dpcman) translates to 'c:\program files\dpc manager
>10' on my development PC (where I'm having
>the problem.
>But I have the same problem if I substitute 'c:\ ....' etc in the code, so I
>gues its not UNC related.

Well, that was worht a shot. Hmm, Program files? That's an unusual folder to place
temporary documents as it will be read only for a regular user.

>Is there a documented limit on the length of path names or the number of
>levels?

Somewhere it's documented but the limit is 255 characters or similar. I've
experimented a bit myself by creatiing a folder name with 5 x 01234567890 and then
cutting and pasting the folder name.

[Bob Darlington]

Thanks Tony.
As per my original post, I'm working well within 255 char.

--
Bob Darlington
Brisbane
"Tony Toews [MVP]" <tto...@telusplanet.net> wrote in message

news:16utg5dl8c3vmnsu6...@4ax.com...