Prev: Hate Your Job?
Next: Working with many-to-many relationships in Access 2007
From: Aldric on 30 Jun 2008 00:30
I want to be able to "lock" a record once it has been created, I am using
auto-number as the data type, that will show that the record has been
deleted, but not the details, but want to try and prevent editing and
deletion.
Thanks in advance
Aldric
From: Allen Browne on 30 Jun 2008 01:15
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
at:
http://allenbrowne.com/AppAudit.html

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.

"Aldric" <Aldric(a)discussions.microsoft.com> wrote in message
news:AA4164EB-1203-4F1A-9FB1-CD60D794717D(a)microsoft.com...
>I want to be able to "lock" a record once it has been created, I am using
> auto-number as the data type, that will show that the record has been
> deleted, but not the details, but want to try and prevent editing and
> deletion.
> Thanks in advance
> Aldric

 | 
Pages: 1
Prev: Hate Your Job?
Next: Working with many-to-many relationships in Access 2007