How to lock tables

[sivakumari]

hi,
i have created a table with 2 records.i want to lock the record such that nothing can be done with the existing records but allows to add new records.wat should i do??
thank u

 

[statsman]

If your only method of data entry or editing is a form, its simple.
Open the form in design view and then open the properties for the text boxes you don't want altered.
On "enabled" click no
On "locked" click yes.
This will allow the data to be viewed by not edited.

This will also apply to all of the data in these fields for that form.

 

[sivakumari]

then how to add new records

hi, if doing so how can i enter data through form?

 

[WayneRyan]

Set the Form's DataEntry property to Yes. You will only be able to add new
records.

Wayne