Length limit for FileName within TransferText?

[Perry]

I have a set of queries that run fine. But when I attempt to run a macro to
export each of these to a separate CSV file, I get an error of object not
found. After trying several things, it appears that the length of the path
and filename that was coded is too long. I am running Access2000 under a
Windows2000 OS. Does anyone know if there is a limit to the length of the
path & filename that can be used? The length I was attempting and failing
with was 144 characters which does not seem excessive.

 

[Steve Schapel]

Perry,

I was not aware of any such limit. Do you mean the macro works if you
try to export to a path/filename that is shorter, but not with the
144-character one?

 

[Perry]

Correct. I have experienced this problem with separate macros in 2 separate
Access DBs. In one instance the path name had an '&' character which made me
wonder if that was causing the problem but I have experienced the error in
with out the '&'. In both instances, the length of the path and filename
exceeded 140 characters.