TransferText command

[Guest]

I have successfully transferred some data from a table in my database to a
text file in exactly the format I want using the Export Wizard. Then I come
to automate the process via either a Macro or VB. When I trigger the
TransferText command I get
Run-time error '3027':
Cannot update. Database or object is read-only.

I don't understand this as the wizard works, so why doesn't the command?
What can I do?

 

[Douglas J. Steele]

What's the file extension of the file? If it's anything other than txt, csv,
tab, asc, htm or html, you'll get that error.

See the following KB articles for more details (don't worry about what
versions of Access are listed in the articles: it applies to all versions
since Access 97 SP2)

"Can't Update. Database or Object Is Read-only" Error Message When You
Import Files
http://support.microsoft.com/?id=247861
"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

 

[Guest]

Thanks Douglas it worked first time!

What's the file extension of the file? If it's anything other than txt, csv,
tab, asc, htm or html, you'll get that error.

See the following KB articles for more details (don't worry about what
versions of Access are listed in the articles: it applies to all versions
since Access 97 SP2)

"Can't Update. Database or Object Is Read-only" Error Message When You
Import Files
http://support.microsoft.com/?id=247861
"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