I want to create a database for a training log in which the data cannot be
altered once its entered.
Well, you're talking about a computer file on disk here. There is no
way to ABSOLUTELY ensure that a file cannot be changed. A determined
user, intentionally trying to violate your stated rules, can work
around almost anything. Are you concerned about inadvertant,
unintentional alteration, or someone deliberately and surruptitiously
changing it?
The best you can do in Access is to implement Access database
security. Set it up so that only authorized users (you or a very
select set) can correct errors in the data, manage the tables, etc.;
everyone else would be able to connect with the data ONLY using Forms
and RWOP queries which limit updates as you desire. A Form can be set
up with Allow Additions = True and Allow Updates = False, but that (by
itself) is much too easy to get around.
John W. Vinson[MVP]
