Exporting table to text file without .txt extention

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to export a table to a text file but I do not want the file name to have a file extention. When I try to do the export I get the following error message: “Cannot update. Database or object is read-only.†If I add the .txt file extention the export works fine. Can anyone help me with this problem?
 
It's a "security feature" introduced in Access 97 by one of the service
packs and perpetuated ever since.

See
http://support.microsoft.com/?id=245407
http://support.microsoft.com/?id=304206


--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


Joel said:
I need to export a table to a text file but I do not want the file name to
Click to expand...
have a file extention. When I try to do the export I get the following
error message: "Cannot update. Database or object is read-only." If I add
the .txt file extention the export works fine. Can anyone help me with this
problem?
 
Hi Joel,

It appears as if you must use a file extension that is in a "recognized" list. This is for
security reasons. You can edit the registry to add additional extensions to the recognized list,
but I doubt that you'll have any success exporting without an extension.

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When You Import or Export
Files
http://support.microsoft.com/?id=245407

You could always try renaming the file via code, after the export was completed.

Tom
_____________________________________________


I need to export a table to a text file but I do not want the file name to have a file extention.
When I try to do the export I get the following error message: “Cannot update. Database or
object is read-only.†If I add the .txt file extention the export works fine. Can anyone help
me with this problem?
 
Back
Top