Re: Operation Must Use An Updateable Query!? - NOT Permissions - CrossTab!!??
- From: Tom van Stiphout <no.spam.tom7744@xxxxxxx>
- Date: Wed, 31 May 2006 07:17:58 -0700
On 31 May 2006 06:55:25 -0700, "Bob" <bobg.rjservices@xxxxxxxxx>
wrote:
Yes, that's very annoying. Access apparently is too stupid to
understand this. We'll see about Access 12, but my guess is that 98%
of the effort went into a new UI, and very little into improvements
like this one. My workaround is to write the results of the crosstab
to a "temporary" table, and then use that table to complete the rest
of the update.
-Tom.
running access 2k; mdb w/ linked tables to another mdb
(front/back-end);
trying to run a query that updates a table FROM information from a
crosstab query.
I AM NOTT trying to update the crosstab query itself - only use
information FROM it to update a perfectly updatable table!
Why the ---- would I get this error, when there are clearly NO
permission issues, or issues in updating the table I'm trying to
update!?!?!?!? (I can clearly update it without the XT)
What the ---- good is a crosstab query, if I can't USE the information
within it for something other than reporting?!?!?
Here's my query (the "XT" table is my crosstab):
I'm guessing that maybe I need to use a sub-query to work around this,
but am not sure how, nor why I should have to go this route....
UPDATE Q_answers_XT LEFT JOIN T_final_answers ON
Q_answers_XT.id = T_final_answers.id
SET T_final_answers.q = [Q_answers_XT]![q], T_final_answers.a =
[Q_answers_XT]![a];
any help appreciated...
TIA
.
- Prev by Date: Have Autocomplete entries travel with MS access database
- Next by Date: Re: Making a copy of the current database using code
- Previous by thread: Have Autocomplete entries travel with MS access database
- Next by thread: Re: Operation Must Use An Updateable Query!? - NOT Permissions - CrossTab!!??
- Index(es):
Relevant Pages
|
