Unchangeable field

  • Thread starter Thread starter MarianneZ
  • Start date Start date
M

MarianneZ

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?
 
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
 
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
 
plz i want help sir ,
can u help me ..
i want code for vb.net access database feild remains unchangable on run time
 
Back
Top