View Single Post
  #2  
Old April 27th, 2004, 10:16 PM
Steve Schapel
external usenet poster
 
Posts: n/a
Default Preventing Records from being deleted?

Amy,

Generally speaking, tables can be seen during the development and
testing phases of your database, but should not be exposed to the user
in normal usage. The data should be accessed via forms, which are
designed for this purpose. In this case, a form has properties which
can be adjusted to achieve the effect you want, i.e. set the
AllowDeletions property (and maybe also the AllowEdits property?) to No.

--
Steve Schapel, Microsoft Access MVP

Amy Johnson wrote:
Is it possible to lock a table so that new records can be
added but existing ones can not be deleted?