Unchangeable field

Discussion in 'Access Table Design' started by MarianneZ, Feb 5, 2009.

  1. MarianneZ

    MarianneZ Guest

    In my table I have 2 fields that I do not want users to change. It's okay if
    Vba code changes the values, but not a user directly. Is there any way to
    enforce this?
    MarianneZ, Feb 5, 2009
    1. Advertisements

  2. Change the LOCKED property to YES. You can change it to NO in VBA if you
    need to make changes and then change it back so users can't. You will find
    the property in the DATA tab of the property sheet.

    bhicks11 via AccessMonster.com, Feb 6, 2009
    1. Advertisements

  3. MarianneZ

    MarianneZ Guest

    I know I can do this in a form. It's in the table that I want the field to be
    readonly. Don't other people need this capability also?

    Do I need to force my users to go through a menu and a form? How do I
    prevent them from just opening the table and changing this field? Maybe even
    by accident.

    By the way, I'm using Access 2007 and DAO
    MarianneZ, Feb 6, 2009
  4. Yes, this is something many developers do.
    Use a menu and a form.
    Hide the nav pane from the users and make sure there are no options on the
    ribbon that give users the ability to open the tables directly.

    Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
    Jeanette Cunningham, Feb 6, 2009
  5. plz i want help sir ,
    can u help me ..
    i want code for vb.net access database feild remains unchangable on run time
    Jagan Salunkhe, Apr 22, 2011
    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.