Export text file problem

[Frank H]

Can anybody help me ?

I am using the following line to export some text data...

DoCmd.TransferText acExportDelim, , "qryExportVolume",
strExportFile, True

I get the following error message when the line executes :

"Run-time error '3027':
Cannot update. Database or object is read-only"

I cannot finf anything that is read-only.
I have used this method before without any problems.
The query runs OK by itself, I can run the query via an
export wizard.
I have tried different file names and locations in
strExportFile.
Where am I going wrong?

(Using Access 2002 SP2)

TIA
Frank H

 

[Douglas J. Steele]

What's the name of the file to which you're trying to write? There are
restrictions as to what the extension can be.

Check out the following for more information, and work-arounds:
http://support.microsoft.com/?id=245407
http://support.microsoft.com/?id=306144

 

[Frank H]

Thats it, I was using the extension .vol
Thank you sincerely

Frank H