Update Query To Excel (Error 3113)

[Guest]

In Access, I have a query that will update a 'linked' excel spreadsheet. The
query used to work perfectly fine, but now I only get an error message Error
3113. Per my IT department, they are suggesting that the message seems to be
attributed to something that changed in Service Pack 2. I am running running
Excel and Access, Service Pack 2.

The SQL Query:
"UPDATE [Totals] LEFT JOIN [Bank] ON [Totals].F1 = [Bank].F1 SET [Bank].F1 =
[Totals].F1, [Bank].F13 = [Totals].SumOfF13
WHERE ((([Totals].[Version])="995"));"

The Error Message:
Cannot Update <field name>; field not updatable. (Error 3113)

Any ideas???

Thanks!!

 

[Allen Browne]

Yes, see:
http://support.microsoft.com/kb/904953/en-us

If I understand correctly, Microsoft lost a court case, and had to pull this
functionality out of the product. The service pack therefore broke the
ability for Access to update Excel spreadsheets as it had done previously.

 

[Guest]

Thanks for the informaton. I will check it out. I wonder what the heck the
case was about, as it causes some problems for me now.

--
CMac

Yes, see:
http://support.microsoft.com/kb/904953/en-us

If I understand correctly, Microsoft lost a court case, and had to pull this
functionality out of the product. The service pack therefore broke the
ability for Access to update Excel spreadsheets as it had done previously.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

In Access, I have a query that will update a 'linked' excel spreadsheet.
The
query used to work perfectly fine, but now I only get an error message
Error
3113. Per my IT department, they are suggesting that the message seems to
be
attributed to something that changed in Service Pack 2. I am running
running
Excel and Access, Service Pack 2.

The SQL Query:
"UPDATE [Totals] LEFT JOIN [Bank] ON [Totals].F1 = [Bank].F1 SET [Bank].F1
=
[Totals].F1, [Bank].F13 = [Totals].SumOfF13
WHERE ((([Totals].[Version])="995"));"

The Error Message:
Cannot Update <field name>; field not updatable. (Error 3113)

Any ideas???

Thanks!!