Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Recordset Not Updateable (Access 2000)

    Something strange seems to be happening to my DB. I have a split DB, with the front-end residing on my computer and the data back-end sitting on the network. My DB was working fine, until all of a sudden I started getting "Recordset not updateable" errors on the status bar for only some of the forms. Others in my group are having the same difficulty, but with other forms.

    All of my forms are based on queries.

    The fields I am trying to update are not locked and Record Locks proprty is set to "No Locks".

    My whole database runs on only three tables (one of which is the main table and a few smaller ones), all of which have primary keys - which is what the MS KB says is the problem. Obviously not in this case.

    This is what I have tried so far:
    - Compact and repair on the front end and the back end
    - Refresh the links to the tables
    - Delete the linked tables and re-link them

    Like my database, I am completely stuck. Any ideas?

    Thanks,

    JoeK

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Recordset Not Updateable (Access 2000)

    Does this problem occur only when multiple users are active simultaneously, or does it also occur when a single user is active?

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Jerusalem, Israel
    Posts
    187
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Recordset Not Updateable (Access 2000)

    Hans,

    I feel a little foolish. I had set the property of one of the forms to "Record Locks - All Records". That is what caused the problem. Once I set it to "No Locks" I no longer experienced this problem.

    Thanks for your help, anyway.

    JoeK

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Recordset Not Updateable (Access 2000)

    It happens to all of us... <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •