Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Why I can't modify data in Query, while in the Table can do

Discussion in 'Information Technology' started by Martin, Nov 9, 2005.

  1. Martin

    Martin
    Expand Collapse
    Guest

    In the Table, I can modify the data, but when I enter the Query which is
    generated by this Table, I can't modify the data in this Query.

    Why? How to solve this problem?

    Thanks!

    Martin
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    The query results will be read-only if any of the following apply:

    .. 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's Recordset Type property is set to Snapshot.

    .. 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.

    "Martin" <lajitong888@21cn.com> wrote in message
    news:ui1IeqN5FHA.3496@TK2MSFTNGP10.phx.gbl...
    > In the Table, I can modify the data, but when I enter the Query which is
    > generated by this Table, I can't modify the data in this Query.
     

Share This Page