Help to Export to txt file:DB Read only ?

[HM]

Hello,
Whenever, I run this error happen I do not know what
wrong , please advice.
The error is: "Run time error 3027 - Can not update.
Database or Object is read only."

Here is my code:
DoCmd.TransferText acExportDelim, "Export_Txt", _
"dbo_temp", "c:\Access Projects\TextFiles\Tranfer.doc"
Thanks in advance.
HM

 

[Douglas J. Steele]

Believe it or not, it's because of the file extension. See the following KB
articles:

"Can't Update. Database or Object Is Read-only" Error Message When You
Import Files
http://support.microsoft.com/?id=245407
How to Import a Text File That Has an Extension That Access Does Not
Recognize
http://support.microsoft.com/?id=306144