Operation must use an updateable query

[sdkramer]

OK I'm trying to run an update query. I have a table from which I wish to get a large amount of my data, it's a table that's sort of denormalized so we our users can run simple queries on it and get a variety of data. Here's what happens:

When I use the denormalized table, call it foo, and update a field in my resulting table, call it bar, such that bar.a gets foo.a, and I have a join on foo and bar on the ID field It says "Operation must use an updateable query"

If I go through the much more difficult way 8 tables linked, and a bit of logic and flow control to control multiple returns it works. What's the deal? the easy way should work here, and I have a bunch of fields to update. is there anyway I can make the denormalized table work?

I know this error message gets quoted alot I looked and I saw 12 entries, but none of the previous responses seemed to apply to my situation.

Any help would be appreciated,

Seth Kramer

 

[Pat Hartman]

There are various reasons that a query might not be updatable. Check the knowledge base for a comprehensive paper on the topic but common reasons are:

1. The query contains an aggregate function.
2. Jet cannot determine the cardinality of the relationship because one or more of the tables does not have a primary key.
3. You don't have update permission to one of the tables.
4. The tables are not properly joined. This happens when people use the old style syntax where the join is not specific (Inner, left, right) but justs lists one or more tables in the From clause - tblA, tblB, tblC.