TransferSpreadsheet to Link an Excel File

[scking]

I've been attempting to link an Excel file using the line of code following. I get an Error 3027, "Cannot update. Database or object is read-only" and can not determine the cause. The filename is "ANALYST-OUT-DATA (5N1-4-23-14).xls" which I have delimited with quotes because of the space in the filename.

'----------------------------------------------
DoCmd.TransferSpreadsheet TransferType:=acLink, SpreadsheetType:=acSpreadsheetTypeExcel97, TableName:="tmpUOC", Filename:=strFile

Any help explaining the cause and possibly correction of this error would be appreciated.

-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------