How to prevent users from deleting records?

Discussion in 'Access Security' started by Connie, May 17, 2010.

  1. Connie

    Connie Guest

    Access 2007

    I have created a database for users to create records (ex: call requests).
    How to I protect these records so the users can't go back and accidentally or
    maliciously delete them once they've been added.
    Connie, May 17, 2010
    1. Advertisements

  2. Don't let them have access to the tables, and set the Allow Deletions
    property of the form to False (No)
    Douglas J. Steele, May 17, 2010
    1. Advertisements

  3. In addition, you might let them think they are deleting records, by giving
    them a Delete Button that marks the records as not visible.

    Ad a Boolean (yes/no) field to your table. Change the recordsource of your
    forms and reports to only show records not marked

    The code in the delete button should read something like:

    Me.chkNotVisible = True
    Arvin Meyer [MVP], May 18, 2010
  4. Connie

    david Guest

    If you are using the MDB format, remove the Delete Data
    permission for the table, to prevent users accidentally
    deleting records.

    You don't have to set up user level security to do this.

    If you do want to delete a record, you can just add the
    Delete Data permission back, delete the data, then remove
    the permission again.

    david, May 20, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.