I am using the transfertext action in a macro to export a query to a text file on the network. It works when the text file on the network does not exist, however, when I try to run it when the text file is there... it won't replace it. Instead it gives me "Can't Update. Database Oject is Read-Only" error. The text file on the network is not a read-only file. Any ideas on why this isn't just replacing that existing text file?

Thanks!

This isn't an answer as much as a call for help. I, too, am trying to use the TransferText in Access and also keep getting the message "Can't Update. Database Oject is Read-Only." However, in my case, the text file doesn't exist anywhere yet. My query is very simple so I cannot understand this error.

Check your file extension... I just had this same issue and it turns out that unrecognized file extensions will cause this. In my case, the file extension was typo'd! Had an extraneous space after .txt (so .txt(space)) Removed space and all is well.