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



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?



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!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question