Operation Must Use An Updateable Query (1 Viewer)

[Aaron Greatbanks]

I just altered and update qeury so that it's a wuery based on a table and a qeury but when i run it is comes up with Operation Must Use An Updateable Query

This is the SQL Code:

UPDATE tblStudent INNER JOIN [qry=3ForCrossTableQuery] ON tblStudent.[Student ID] = [qry=3ForCrossTableQuery].[Student ID] SET tblStudent.WWOCompleted = True
WHERE ((([qry=3ForCrossTableQuery].[Total Number Of Unit])=3));

How do i resolve this?

 

[jdraw]

Here are reasons why a query is not updateable -- see if it applies to your situation.
http://allenbrowne.com/ser-61.html
Good luck.

 

[mail2poov]

I am also getting the same error while I am doing insert.

1) Below insert statement is working fine - here Inserting into access table from linked excel table
strSQL = "Insert into tblAccessTag Select * from ExcelTag"
CurrentDb.Execute strSQL

2) strSQL = "Insert into ExcelLinkedTbl Select * from tblAccessTag "
CurrentDb.Execute strSQL

this give error with Operation must use an updatable query. (Error 3073) Microsoft Access

-- The excel not opened. The access table and Linked table not opened in Access. The excel file is not read only

Any help to solve this please.

 

[boblarson]

You can't update Excel as a linked table. Microsoft lost a lawsuit many years ago around that technology and so the way you would update the Excel file is having to use the Common Object Model to open it via code and then do the update through the code.