Re: what makes this query not updatable
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Fri, 27 May 2005 00:27:37 +0800
Lynn, make sure the Name AutoCorrect boxes are unchecked under:
Tools | Options | General
Then compact the database.
If the bad relationships return, delete these relations, and compact again.
You should then be able to recreate them, and have them behave properly.
Once that's sorted out, you may find that the query settles down and behaves
as expected, i.e. the problems are actually the result of an incipient
corruption.
Most of the common reasons for read-only queries don't apply in your case,
but here's my standard list anyway:
.. It has a GROUP BY clause (totals query).
.. It has a TRANSFORM clause (crosstab query).
.. It contains a DISTINCT predicate.
.. It uses First(), Sum(), Max(), Count(), etc. in the SELECT clause
(performs aggregation).
.. It involves a UNION.
.. It has a subquery in the SELECT clause.
.. It uses JOINs of different directions on multiple tables in the FROM
clause.
.. The query is based on another query that is read-only (stacked query.)
.. Your permissions are read-only (Access security.)
.. The database is opened read-only, or the file attributes are read-only, or
the database is on read-only media (e.g. CD-ROM, network drive without write
privileges.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"lynn atkinson" <lynnatkinson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7051E8CB-102B-4665-97B7-87A217681478@xxxxxxxxxxxxxxxx
> found the cause of this. Somehow I had the employee details table twice in
> the relationships. I have now deleted this but I am still not
> understanding
> why the more complex queries with employee details and contracts tables
> etc
> are not updateable
>
> "Allen Browne" wrote:
>
>> Lynn, why is the "ON" duplicated in the JOIN?
>>
>>
>> "lynn atkinson" <lynnatkinson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:872C6051-4D4C-41CA-9CAE-8D08FD8B0D84@xxxxxxxxxxxxxxxx
>> >I have a simple query connecting employee details to their contract
>> > information. Why is this not an updatable query? It is a one to many
>> > relationship - an employee can have many contracts.
>> > Can anyone explain simply to me why this cannot be updated? What can I
>> > not
>> > see? Is it a design fault?
>> > The sql of this example is
>> > SELECT employeedetails.surname, contractual.[contract type]
>> > FROM employeedetails INNER JOIN contractual ON
>> > (employeedetails.[employee
>> > ID
>> > new] = contractual.[employee ID]) AND (employeedetails.[employee ID
>> > new] =
>> > contractual.[employee ID]);
>> >
>> > This is quite fundimental to my database.
>> > Cheers
.
- References:
- what makes this query not updatable
- From: lynn atkinson
- Re: what makes this query not updatable
- From: Allen Browne
- Re: what makes this query not updatable
- From: lynn atkinson
- what makes this query not updatable
- Prev by Date: Re: what makes this query not updatable
- Next by Date: Query for Last Inventory Count
- Previous by thread: Re: what makes this query not updatable
- Next by thread: RE: what makes this query not updatable
- Index(es):
Relevant Pages
|
