A
AFSSkier
I was using Access97 & now have 2003 installed. I’ve converted my 97 DB’s to
2003.
All of the Update Queries that update fields in linked excel spreadsheets do
not work. I get the following error message. “Cannot update ‘(expression)’;
field not updateable (Error 3113)â€.
To test the query, I imported the excel spreadsheet as a table with the same
name. 2003 will update the imported table, but will not update a linked
spreadsheet. Is there something on 2003 that may not be installed on my
computer?
Here is a test SQL that works on Access97, but not 2003.
UPDATE update_test INNER JOIN [DIV 1] ON update_test.ITEMNO = [DIV 1].ITEMNO
SET update_test.COST = [DIV 1]![COST];
2003.
All of the Update Queries that update fields in linked excel spreadsheets do
not work. I get the following error message. “Cannot update ‘(expression)’;
field not updateable (Error 3113)â€.
To test the query, I imported the excel spreadsheet as a table with the same
name. 2003 will update the imported table, but will not update a linked
spreadsheet. Is there something on 2003 that may not be installed on my
computer?
Here is a test SQL that works on Access97, but not 2003.
UPDATE update_test INNER JOIN [DIV 1] ON update_test.ITEMNO = [DIV 1].ITEMNO
SET update_test.COST = [DIV 1]![COST];