General discussion

  • Creator
    Topic
  • #2175627

    Access 200 Project – Recordset is not updateable

    Locked

    by vishalsood007 ·

    Hi,

    I am a DBA and am trying to modify an Access 2000 Project made by someone else. Access forms file is on my pc while the database file is kept on server.

    When I try to modify data in any table or form, I get error msg – “This recordset is not updateable”.

    Whereas when I try to modify data in another database file after creating new forms and by exactly the same way & kept on that same server, I am able to do it!

    Need urgent help on this. Waiting.

    Vishal Sood

All Comments

  • Author
    Replies
    • #3350655

      Reply To: Access 200 Project – Recordset is not updateable

      by clesafe ·

      In reply to Access 200 Project – Recordset is not updateable

      There could be many things done with your database. But let us start eliminating the obvious. First open the database and check the user and group permissions via tools on the menu. Make sure that the objects (Tables) you want to update have the update permission checked. Secondly Ensure the table owner is you or admin and not the person who developed.

      If it does not fix contact me again.

      • #3325672

        Reply To: Access 200 Project – Recordset is not updateable

        by vishalsood007 ·

        In reply to Reply To: Access 200 Project – Recordset is not updateable

        I have been able to solve the problem.

        Issue actually lies with the primary key definition.

        If a table is made with primary key, data is entered and then primary key is removed, access does not allow to modify / delete / insert new data & gives message that “Recordset is not updateable” !!

        Hope it helps others too!

        Chapter closed!:)

    • #3325671

      Reply To: Access 200 Project – Recordset is not updateable

      by vishalsood007 ·

      In reply to Access 200 Project – Recordset is not updateable

      This question was closed by the author

Viewing 1 reply thread