Error Number: 3027 -- Can't Update. Database or object is read-onl

[Guest]

I am using Access97 to save query results to a fixed-length file. Here is
the command:

DoCmd.TransferText acExportFixed, "ItemUPC Export Specification",
"qryItemUPC", txtOutputFileName, False, ""

This works OK on MY PC, but NOT on another person's PC. They get the
following message:

Error Number: 3027
Source: MSAccess
Description: Can't Update. Database or object is read-only.

I verified that the Windows file attributes do NOT say "read-only". They
get the same message even when the DB gets moved to a different location.

Any suggestions?

Thanks,
Bruce

 

[Guest]

I found my own answer.

Access would not write the file because I was not using a "known" file
extension. Evidently, MY PC will allow that, but the other user's PC would
not. I have changed to using a ".txt" file extension and all is well!