Results 1 to 7 of 7
  1. #1
    CHEECO is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2016
    Posts
    156

    Operation must use an updateable query

    I have a database that is using "Liam Sullivan Security Levels 2012b" Login. It works fine on my computer but when I put the database on another computer and the user tries to change there pass word as required for first time user login they are getting the error "Operation must use an updateable query". Need Help.

    Thanks cheeco

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    KNOWLEGE IS POWER
    unfortunately you haven't provided us with any knowledge to help us help you. So you still have the power.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    does the user have write access to the data?

  4. #4
    CHEECO is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2016
    Posts
    156
    Yes the user has administrative rights.

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    guess 2, the user does not have access to the back end
    guess 3, the user has not enabled macros
    guess 4, the user has not put the fe in a trusted location
    guess 5, no idea what "Liam Sullivan Security Levels 2012b" is, but perhaps it requires a library not on the users computer

  6. #6
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    guess 5 - the form is based on a query. That query is not updatable i.e. the value (default or old password) cannot be changed. This
    It works fine on my computer
    could mean anything. Presumably you haven't tried to change your own password. If you can, then forget #5
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #7
    CHEECO is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2016
    Posts
    156
    I don't know why but it is working fine now.

    Thanks for all the help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Operation must use an updateable Query?
    By tonygg in forum Access
    Replies: 3
    Last Post: 09-25-2017, 09:28 AM
  2. Operation must use an updateable query - help
    By fluffyvampirekitten in forum Access
    Replies: 5
    Last Post: 01-08-2016, 08:11 AM
  3. Replies: 3
    Last Post: 11-26-2013, 01:45 PM
  4. Operation must be an updateable query! Arg
    By redbull in forum Queries
    Replies: 6
    Last Post: 10-05-2012, 02:04 PM
  5. Operation must use an updateable query
    By skaswani in forum Queries
    Replies: 0
    Last Post: 12-23-2010, 11:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums