Locking fields

  • Thread starter Thread starter Allen
  • Start date Start date
A

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??
 
Using your FORM's current event procedure:
if not me.newrecord then
me.allowedits = false
end if

Jeff
 
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??
Click to expand...

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
 
Back
Top