read only error

J

Jay

Thanks in advance.

I am trying to transfer data to an network folder.
Error message: Run-time error '3027' Cannot update. Database or object is
read-only.

I believe THIS TABLE IS NOT READY-ONLY.
Any comment is greatly appreciated.
(VBA Script)
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Report",
OutPutFile, True, "A2:C5"

Thanks
 
D

Douglas J. Steele

What's the value in OutputFile? Specifically, what's the file extension to
which you're trying to write? If it's not .xls, I believe you'll get that
error.
 

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

Similar Threads

Transfertext Error - Database or object is read only 1
expected format 2
docmd.transferspreadsheet help?? 2
Error in code exportin tables to excel 0
Export to the Back End Folder 2
Code required to close a form & hyperlink ... 4
Export to Excel when password protected 3
export using transferspreadsheet 1

Top