Locking fields

[Allen]

How do I prevent people using my data base from changing
values in the fields. Kind of locking that field from
being accessed and changed??

 

[JeffW]

Using your FORM's current event procedure:
if not me.newrecord then
me.allowedits = false
end if

Jeff

 

[Tim Ferguson]

How do I prevent people using my data base from changing
values in the fields. Kind of locking that field from
being accessed and changed??

The definitive answer is to implement Access user-level security.

The easier and more informal way is to set the textboxes on the forms to
Enabled=False and Locked=True, but you can't stop a determined user from
attacking the tables directly or using VBA or a query to edit stuff.

B Wishes


Tim F