Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to fix error 3027 ?

Status
Not open for further replies.

essnrv

Programmer
Jun 27, 2002
229
IN
Hi,

I am getting error " 3027: Cannot update. Database or object is read-only." when trying to export table into word document. I am using below code to export

DoCmd.TransferText acExportMerge, , "CGSList", MyDir & "\CGSList.doc"

Am I missing anything on my system or any code problem ?

Thanks in advance
 
The document you're trying to write to is flagged as read only. That's why it complains.
 
Initially, Document doesn't exists at all. For test run I saved manually one file with save name, still getting same error, whether document exists or not. doesn't matter

Thank you,
 
The only thing I can find is a KB which blames security as the issue - probably a shot in the dark, but you can look at it:

Article ID : 245407 You receive "Can't update. Database or object is read-only" error message when you import or export files in Access 2000

VBSlammer
redinvader3walking.gif

"You just have to know which screws to turn." - Professor Bob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top