Post reply

HELP :: Operation must use an updateable query.

  • December 14, 2004 at 8:44 am

    #65862

    Hoping someone can help....

    One of our users is using Access to connect thru ODBC to pull data that will update Access tables on her local machine. Recently she has begun recieving the error 'Operation must use an updateable query.'

    Has anyone else experienced this type of error? I can re-create the same error on Windows XP/2000 with Office 2000/XP....

    I'm at a loss as to what could be causing the problem. Thanks in advance for your help :: MATT

  • December 14, 2004 at 9:52 am

    #533800

    A couple of different things could be causing this.

    1.  NO primary key on one of the tables

    2.  The UPDATE is attempting to UPDATE more than 1 table

    thats all I have for now....



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • December 14, 2004 at 10:09 am

    #533805

    Also refresh the linked tables through the tools menu in case the structure of the table has changed.

    ------------------------------
    The Users are always right - when I'm not wrong!

  • December 14, 2004 at 11:36 am

    #533823

    Putting a primary key on the table didn't work and there is only 1 simple table being updated.

  • December 14, 2004 at 11:38 am

    #533824

    I just updated the linked tables...Unfortunately that did not help at all.

    Thank you guys very much for your suggestions...please keep them coming!

    Thanks :: MATT

  • December 14, 2004 at 5:18 pm

    #533871

    Try to delete and rebuild this link from scratch, do not just refresh. 

    MS Access will ask you about unique key, make sure you select unique key. Good luck!

  • December 15, 2004 at 5:58 am

    #533922

    Is the Access file read-only?

  • December 15, 2004 at 5:58 am

    #533921

    HI

    Its not much more just changing rights at databse directory.

    just check the rights at directory when u are placing ur Databse.

    grant full permission to that directory as well databse..

     

    it will work fine,

    I checked this tip, when i got same error.

     

    apply and enjoy.....

  • December 15, 2004 at 7:40 am

    #533949

    I have full rights on the file and I'm also a DBO on the SQL Table with a DSN using NT Auth. I don't believe that rights are the issue.

  • December 15, 2004 at 7:41 am

    #533950

    The file is NOT read-only.

    Thanks for the help!

  • December 15, 2004 at 7:44 am

    #533952

    Just rebuilding the link did not work, however when I rebuilt and selected a unique key it did seem to work in one example. I will test more and let you know how I make out.

    In the past we have experienced problems with defining unique keys through DSN's, is there any downfall to choosing a DSN or choosing a unique key that differ from the keys on the SQL Table?

    Thanks for the idea, I hope it will be a working solution. I'll post more later.

    :: MATT

  • December 15, 2004 at 8:20 am

    #533963

    In Access, when you pull up the linked table in design mode, is the unique key recognized and marked as the primary key?

  • December 15, 2004 at 9:05 am

    #533971

    Hi,

    Try setting rights on the folder in which the mdb reside in.

  • December 15, 2004 at 9:27 am

    #533980

    For all of the tables yes, but some of the linked views do not have their keys defined.

    Thanks!

  • December 15, 2004 at 9:28 am

    #533981

    I have more full permissions to the directory that the .mdb resides in. I have tried running the update query with the .mdb in numerous places with all rights with out success.

    Thank you for the response!

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply