TransferText Problem

[barlowr70]

I have a dB that's recently been upgraded from Access 97 to Access 2002_XP. I'm trying to export data to a text file using an existing specification as follows...

DoCmd.TransferText acExportDelim, "mySpec", "myQuery", "c:\myFile.txt"

But I keep getting the following error...

The Microsoft Jet database engine cannot open the file 'myFile.txt'. It is already opened exclusively by another user, or you need permission to view its data. / 3051

The text file is actually being created on the fly and doesn't exist prior to the line of code being executed. The file is being created but somehow in readonly mode. This has worked in the past in Access 97 without any problems. If I export the query manually usig the specification is works also.

Thanks in advance
Roy

[barlowr70]

corrupt specification