Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Posts
    3

    Smile Unanswered: Protecting Data in MS Access 2003

    Hi,
    I have created a DB with a unique identifier # which acts as a record number. Each record is tied into multiple forms in the database. Once a record is complete, I want to be able to write protect the data, so it can't be modified.
    I hope I explained this well enough. Thanks for your help.
    Scott

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The easiest answer I can think of is to set your AllowEdits for the relevant forms to No during your Form_Current event procedure and only set it to Yes when at a new record.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Aug 2009
    Posts
    3

    Thank you

    I will give it a try. Much appreciated!
    Scott

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    StarTrekker has given you the standard way of doing this, but here's two questions you need to consider:

    1. What/when is a record considered "complete?"
    2. How are you going to edit a record if incorrect data has been entered?

    Item #1 can be as simple as when the record is originally saved, or may involve having all fields populated or certain fields populated.

    Item #2 will definitely need to be addressed unless the data is part of something like an online exam or some kind of report where you're sure you'll never want the original data changed.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Aug 2009
    Posts
    3
    1. The user and DB manager determine when the record is complete.
    2. Ultimately I'd like a Button on the form that would lock the record and another to unlock it for edits.

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    StarTrekker is going the same place I would.

    I would be inclined to track the status of any given record by way of either a yes/no field or a "status id" that relates to all the statuses your record can have. Evaluate that field to toggle the AllowEdits property of the form, as StarTrekker suggests.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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