Run-Time 3027 Cannot update. Database or object is read-only.

[ARW17]

I'm trying to export the results of a query (ENTRY_TINITIALS) to an Excel workbook (Entry_Staff.xlsx) where I'll then use another tab in the Excel workbook to format the data.

I have a button with this code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "ENTRY_TINITIALS", "K:\AUR Office Databases\Office Performance Database\Analyst\Entry_Staff.xlsx!Sheet1"

But I'm getting this error:

I thought it might be a Reference issue? Here's what I have checked:

 

[Joe4]

What kind of query is "ENTRY_TINITIALS"?
Is it a Select query or an Action query?
Does it prompt for parameters?

Is "K:\AUR Office Databases\Office Performance Database\Analyst\Entry_Staff.xlsx!Sheet1" an existing file, or a new file that you are creating?
Did you verify that the path is good (that you have a K drive mapped, and the file path is correct with no typos)?

 

[ARW17]

ENTRY_TINITIALS is a select query. It does not prompt for parameters.

Looks like it doesn't want the !Sheet1 ending of the path, which works for me.

 

[Joe4]

Looks like it doesn't want the !Sheet1 ending of the path, which works for me.

Yes, that is why I was asking if you are trying to write to an existing file or create a new one.
If creating a new one, you do not need to specify the sheet name.