Update Query, Operation Must Use Updateable Query

[Chris1112]

I've created an update query that pulls information from a source that I do not have write permissions to. It then updates a table with a portion of this information (MAX of a field). I get an error that "Operation must use an updateable query." The table is updateable and I'm not going to get write permissions on this table. What is the best practices method around this?

Thanks in advance.

[orange]

It sounds like you may have already read this info. If not, it may be helpful.

http://allenbrowne.com/ser-61.html

[Chris1112]

Thanks for the response. Yeah, I've read about why I can't use it. I'm just curious how to get around it.

I was able to run a make table query using the data, just not an update query. Maybe I could create a new table then update the current table from it? Hmmm...will try.

[orange]

Can you post the sql?

[Chris1112]

Well, it appears that dumping the information into a new table then using it is the way to go. Using the data straight out of a read-only table makes whatever other fields from other read/write forms read-only as well. So the story is, don't use read-only data as part of a modifiable data set...if that makes sense. Kinda weird that you can't append straight from it though.