If all records are entered through forms (not directly on the
tables/queries), you could set the forms' AllowEdits and AllowDeletions to
No, leaving AllowAdditions as Yes to permit new records.
Another option might be to track edits and deletions instead of blocking
them. Details in:
Audit Trail - Log changes at the record level
In A2003 or earlier, it is possible to set up Access security to give users
permisson to append and read, but not modify or delete. This solution is
best reserved for special cases, especially now the new A2007 format does
not support it.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.