I have a table [tblROPError] that I want to update one field in. I created an Update query that uses a SQL Passthrough query [qryROPTracking] as my data source. I get error: Operation Must Use Updateable Query.
Do I have to write the records from [qryROPTracking] to a table before I can update my table [tblROPError]? Isn't there a better way without having to store records that are already being stored in SQL?
Here is the Update Query:
UPDATE qryROPTracking INNER JOIN tblROPError ON qryROPTracking.adid = tblROPError.AdID SET tblROPError.DEUsername = qryROPTracking!username;
Please help. I want to avoid having to write the records to a table so I don't have a delayed response that the users will feel.