Welcome to SPN

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

Sign Up Now!

Operation must use an updatable query

Discussion in 'Information Technology' started by avi, Nov 16, 2005.

  1. avi

    avi
    Expand Collapse
    Guest

    Getting the error message "Operation must use an updatable query" (3073) in
    Microsoft Access XP (version 10.6771.6735 SP3). We're trying to update a
    linked table using an updatable query in Access. The linked table is linked
    to an Excel file stored on a network drive. The query worked fine until
    Microsoft Office XP was recently updated

    KB873379
    KB890829
    KB873352
    KB895589
    KB837253

    This query was just tested on a machine without the above updates and works
    fine. Is there any patch or workaround available? Thanks,
     
  2. Loading...


  3. giorgio rancati

    giorgio rancati
    Expand Collapse
    Guest

    "avi" <avi@discussions.microsoft.com> ha scritto nel messaggio
    news:64A46251-2A6B-4D0B-941B-AD1982576551@microsoft.com...
    > Getting the error message "Operation must use an updatable query" (3073)

    in
    > Microsoft Access XP (version 10.6771.6735 SP3).

    [CUT]

    Hi Avi,

    read this kb
    ----
    You cannot change, add, or delete data in tables that are linked to an Excel
    workbook in Office Access 2003 or in Access 2002
    http://support.microsoft.com/kb/904953/en-us
    ----

    bye
    --
    Giorgio Rancati
    [Office Access MVP]
     
  4. avi

    avi
    Expand Collapse
    Guest

    "giorgio rancati" wrote:

    >
    > "avi" <avi@discussions.microsoft.com> ha scritto nel messaggio
    > news:64A46251-2A6B-4D0B-941B-AD1982576551@microsoft.com...
    > > Getting the error message "Operation must use an updatable query" (3073)

    > in
    > > Microsoft Access XP (version 10.6771.6735 SP3).

    > [CUT]
    >
    > Hi Avi,
    >
    > read this kb
    > ----
    > You cannot change, add, or delete data in tables that are linked to an Excel
    > workbook in Office Access 2003 or in Access 2002
    > http://support.microsoft.com/kb/904953/en-us
    > ----
    >
    > bye
    > --
    > Giorgio Rancati
    > [Office Access MVP]



    Thanks a lot Giorgio, that helped.

    I hate "legal issues" - bah!!

    avi
     

Share This Page