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

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" <(E-Mail Removed)> wrote in message
news:AA4164EB-1203-4F1A-9FB1-(E-Mail Removed)...
>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

Thanks Allen - very helpful - your site is now on my bookmarks!

"Allen Browne" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:AA4164EB-1203-4F1A-9FB1-(E-Mail Removed)...
> >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
>
>