Prev: Increase Record Limit in Auto Number
Next: Text and only text datatype
From: Aldric on 30 Jun 2008 21:03
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" <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: Increase Record Limit in Auto Number
Next: Text and only text datatype