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
|
|||
|
|||
Preventing Records from being deleted?
Is it possible to lock a table so that new records can be
added but existing ones can not be deleted? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|