Glenn's suggestion is my standard practice. I guess that's because of the industries I've worked in these last 13 years: banks and healthcare. Both require audit trails and tracking user actions.
My users never can delete records unless the records are of no historical value. And that has to be decided by the division director or similarly resonsible person. If records REALLY should be deleted then only the database admin can do it.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "Glenn Lloyd" <argeedblu@...> wrote:
>
> Unfortunately, you can't undelete deleted records. Although this suggestion
> won't help you with your current situation, you should consider adding a
> Boolean field to your table(s) that indicates that the record has been
> 'deleted.' Then instead of actually deleting a record, you simply change
> the value of this field to true. Of course, this strategy only works if
> users are unable to view the data directly and you use forms for all data
> management.
>
>
>
> Glenn
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Watson L
> Sent: Wednesday, May 29, 2013 9:00 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Undelete table record
>
>
>
>
>
> Dear all,
> I have a Access table that has deleted some records on the table. How to
> recover the record thats have been deleted ? please assist me.thanks for any
> reply.
> Best regards,
>
> Watson
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar