Error exporting long file names to excel

[Hernan Castro]

I run acces 97.. everything went ok until 3 days ago when
I installed Windows 2K sp4... since then when I try to
export a table to excel.. let's say to my
server/folder/subfolder/example.xls I get the 3027 error
stating the database or the object is a read only file...

Guess what I uninstalled service pack 4 for Windows 2000
and nothing... the problem is still there...

Ok I got one solution... use the docmd.output to instead
of the docmd.transferspreadsheet.. this works ok for excel
files but what if I want to export a delimited text
file ....

Any thoughts about it?

Thanks in advance,

Hernan

 

[Nikos Yannacopoulos]

Hernan,

If you actually use slashes (/) instead of backslashes (\)
in your code like you did here, then most likely that's
your problem!
If, on the other hand, you did it right in your code and
accidentally wrong here, I'm afraid I can't offer any help.

HTH,
Nikos