Results 1 to 3 of 3

Thread: Data Safety

  1. #1
    New Lounger
    Join Date
    Mar 2012
    Location
    Pennsylvania, USA
    Posts
    5
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Cool Data Safety

    Slightly misleading title, but close as I could get.

    Thanks to johnhutchinson, my database is just about ready to go "live" around here. Now, for one final consideration:

    This db will be used by people who are not Access-savvy. That was always the idea. My question is: how can I set it so the form allows them to EDIT records in the db table, but not to DELETE them?

    I'm projecting that a knowledgeable someone could, if necessary, go into the table to delete a record as needed. The average user will just be editing existing entries, not making sweeping changes to the overall data structure.

    Is the lack of a "Delete Entry" button on the form sufficient to this task or will more be needed?

    Thanks as always for the input!

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    If you look on the Property Sheet, at the properties of the form itself, on the Data tab, there are properties that control just this.
    I would think that you don't want users to create new records either (as you are just reusing existing records)
    AllowDeletions.gif
    Regards
    John



  3. The Following User Says Thank You to johnhutchison For This Useful Post:

    ConanTheLibrarian (2012-03-28)

  4. #3
    New Lounger
    Join Date
    Mar 2012
    Location
    Pennsylvania, USA
    Posts
    5
    Thanks
    3
    Thanked 0 Times in 0 Posts
    John, you have truly made my day. Thank you for the help. =)

Posting Permissions

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