If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Blocking editing by users
Hi
I have two questions; 1. How can I disallow users from editing, adding or deleting records on a form? 2. What is the purpose of allow edits? What value should I set it to? Thanks Regards |
#2
|
|||
|
|||
Blocking editing by users
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...2F secfaq.asp Ken Sheridan Stafford, England "John" wrote: Hi I have two questions; 1. How can I disallow users from editing, adding or deleting records on a form? 2. What is the purpose of allow edits? What value should I set it to? Thanks Regards |
Thread Tools | |
Display Modes | |
|
|