Preventing Records from being deleted?

A

Amy Johnson

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

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top