Help with run-time error 3027

[eAlchemist]

Can someone tell me why I get run-time error 3027: "Cannot update. Databae or object is read-only." when I run this code:

DoCmd.TransferText acExportDelim, "Transaction Data Export Specification", _
"qry_TransactionTransformation", strPath & "TransactionTransformation", True

but this works fine, and it runs off the same tables:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"Hierarchy_Machines", strPath & "Hierarchy_Machines".

When I run the text export manually, it works fine. Any ideas?

Thanks,
Chris

 

[lameid]

Have you edited "qry_TransactionTransformation" without saving it before you try to export it. If so, save it first.

 

[eAlchemist]

No. That's not it. It has been saved.

 

[lameid]

I bet if you change you file name to have a .txt extension it will work (stupid security upgrades).

 

[RobertT687]

Here is a MicroSoft KBase article on this issue:

http://support.microsoft.com/kb/245407/en-us

 

[eAlchemist]

lameid was spot on. Thanks for the help!

Chris

 

[lameid]

RobertT687, brings up a good point about adding other extensions to the registry. Something I had forgotten about. I think it is the same registry key for importing, or at least there is one. Sounds like a Group Policy candidate for me. Nice add.