As far as adding and deleting records are concerned setting the form's
AllowAdditions and AllowDeletions properties to False (No in the properties
sheet) will prevent users doing so in the form.
As regards editing, setting the AllowEdits property will prevent this, but
it will also prevent the user using unbound controls on the form such as a
navigational combo box for instance. Leaving the AllowEdfits property as
True (Yes) and setting the Locked property of each bound control to True and
their Enabled properties to False will prevent users editing the bound
controls while still giving them access to unbound controls.
This is a very low level of security, however, as a user can easily edit the
table(s) outside the form. If you want a higher level of security then you
should consider implementing user and group security. You can find extensive
information on this at:
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
Ken Sheridan
Stafford, England
