TransferText

[sigh]

Hi,
I use this command to export the file. But I got a
mesage as "Cannot update. Database or object is read only"

DoCmd.TransferText acExportFixed, "Report
Export", "qryReport", "C:\" & Me![txtFileName]

Can any one help me?

Any help would be very appreciated.

 

[Glenn]

I've come across a similar message when using certain file
extensions like ".seq" etc. Try exporting using the ".txt"
extension to see if this is what is causing your problem.

Rgds,
Glenn.

 

[Douglas J. Steele]

Check the following:

"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


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

I've come across a similar message when using certain file
extensions like ".seq" etc. Try exporting using the ".txt"
extension to see if this is what is causing your problem.

Rgds,
Glenn.

-----Original Message-----
Hi,
I use this command to export the file. But I got a
mesage as "Cannot update. Database or object is read only"

DoCmd.TransferText acExportFixed, "Report
Export", "qryReport", "C:\" & Me![txtFileName]

Can any one help me?

Any help would be very appreciated.
.