|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Need to protect data inputAs employees update information in the database, I need to make sure the
information cannot be changed. How can I do this? -- Lynniebird "Lynniebird" <Lynnieb***@discussions.microsoft.com> wrote in message So you want your users to be able to update data but not change it? That news:35448502-021E-49AA-ADA9-D8BD9961ADBB@microsoft.com... > As employees update information in the database, I need to make sure the > information cannot be changed. How can I do this? > makes no sense, would you care to elaborate? Keith. www.keithwilby.co.uk Once the data is entered, it needs to be secured so that no changes can be
made. A new entry will have to be made from that point on--no changes can be made to the data after it is entered. Project tracking is very critical in this industry and we must protect from accidental deletes. -- Show quoteHide quoteLynniebird "Keith Wilby" wrote: > "Lynniebird" <Lynnieb***@discussions.microsoft.com> wrote in message > news:35448502-021E-49AA-ADA9-D8BD9961ADBB@microsoft.com... > > As employees update information in the database, I need to make sure the > > information cannot be changed. How can I do this? > > > > So you want your users to be able to update data but not change it? That > makes no sense, would you care to elaborate? > > Keith. > www.keithwilby.co.uk > > "Lynniebird" <Lynnieb***@discussions.microsoft.com> wrote in message Forms have an Allow Deletes property. Set it to No.news:ACD75C64-AE29-4A51-AD7A-7C59B4B6A3B0@microsoft.com... > Once the data is entered, it needs to be secured so that no changes can be > made. A new entry will have to be made from that point on--no changes can > be > made to the data after it is entered. Project tracking is very critical > in > this industry and we must protect from accidental deletes. > To "lock" the contents of a record I would suggest setting the content of a Boolean field in the form's Before Update event. Then in your form's Current event you would set the form's Allow Edits property based on the Boolean field value. Naturally, you would not want to allow access to the Boolean field to your users. HTH - Keith. www.keithwilby.co.uk 
Other interesting topics
MDE application cracking issues
How to split Front end/Back end HELP! cannot access shared folder on mapped network drive Password to Access back end file AllowBypassKey with an .MDE file Locked out I cannot open a DB created by another user on my PC. I have Idea for solving problem the security for files by using How to hide table using User-Level Security |
|||||||||||||||||||||||
