I have one user who has spontaneously begun getting the run-time error 3435, "Cannot delete spreadsheet cells" in Access 2002. (The is an Access error and not an Excel error, as evidenced by the title of the error window, "Microsoft Access".) I cannot re-create this error on any other machine. Of course, the user can't remember anything unusual occurring on his machine prior to this error showing up.
The debugger shows that the error is occurring at the following line of code
-
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tblTempPolyBillingCust", "MonthEndBillingFromSAPA"
-
I can't understand why this line of code would attempt to delete anything. When I do the same exact thing on my machine, not only is it successful, but it does
not delete anything from tblTempPolyBillingCust. I've found occasional mentions of this problem online, but no solutions. Does anyone know what is happening here? Any help is greatly appreciated.