跟踪用户对记录所做的更改/编辑。 [英] Tracking changes/edits made by users on records.
问题描述
大家好。
谢谢你，NeoPa，在我以前的帖子中给予你的帮助 http://bytes.com/topic/access/answer...rm#post3790900
和Z用于突出显示其中的宏观图像。
...
我的数据库差不多完成了，之前我将其发布给用户以进行试验实施阶段（同时我分发各自的用户前端）。
我想创建一个系统：
Hi all.
Thank you, NeoPa, for your kind assistance in my previous thread http://bytes.com/topic/access/answer...rm#post3790900
and to Z for highlighting the macro image in it.
...
My database is nearly done, before I release it to the users for the pilot implementation phase (while I distribute respective user front-ends).
I would want to create a system that:
- 显示我访问某条记录的人，最后一次访问时间和时间 - 就像跟踪更改记录一样（对于管理员。可能需要一些用户身份验证，我在访问安全方面很小心。
- 通知用户是谁当前访问记录，如弹出窗口（我知道这可能会分散注意力，因此在某些时候很烦人，特别是当有人在屏幕上工作时同时收到两到三个弹出窗口时。）
这是一种监控系统（例如，有一个前端监控数据库活动的其他几个前端）。
我知道我需要一个关于这个的整个教程（我正在浏览Bytes上的Access / VBA部分），并希望我能在飞行员的过程中完成它。
使用Access''07。虽然在VBA中仍然是绿色的。
T.提前预定。
S
This is kind of a monitoring system (Having, for example, one front-end monitoring database activities of several other front-ends).
I know I need an entire tutorial on this one (I''m skimming through the Access/VBA section on Bytes), and hope I can pull it through in the course of pilot.
Working with Access ''07. Still green in VBA though.
Thanks in advance.
S
推荐答案
对于每条记录，您可以添加LAST_VIEWED_BY和LAST_VIEWED_DATE列
对于更改，您应该创建一个包含RECORD_ID，ORIGINAL_TEXT，NEW_TEXT，LAST_UPDATED_BY，LAST_UPDATED_DATE列的历史记录表。
希望有所帮助。
For each record, you can add LAST_VIEWED_BY and LAST_VIEWED_DATE columns
For the changes, you should make a history table which includes RECORD_ID,ORIGINAL_TEXT, NEW_TEXT,LAST_UPDATED_BY,LAST_UPDATED_DATE columns.
Hope that helps.
有很多方法可以完成你想做的事情。您将使用哪种方式来确定您真正需要记录的距离以及您愿意编写的代码量，以及您愿意为可能生成的大量数据投入多少空间。
但首先，如果这是一个很高兴的要求，我会建议你尝试与想要它的人交谈。这是一项艰巨的任务，因此请确保您确实需要它：
- 将会有相当多的代码要编写和维护。此代码很容易在应用程序中分散，从而使维护变得复杂。如果你还是VBA的新手，这可能有点太多了。
- 虽然最新版本在这个功能方面取得了一些进展，但Access并不是为此而设计的。桌面数据库。 SQL Server有简单的方法来实现这一目标，成为真正的多用户环境。
- 您可能会生成大量永远不会被使用的数据。
- 任何依赖关于Access的安全性是错误的，因为几乎总有办法解决安全问题。
There are quite a few ways to accomplish what you want to do. Which ways you use will be determined on how far you really need to take your logging and how much code you are willing to write, and how much space you are willing to devote to the possible massive amount of data you could generate.
But first off, if this is a requirement that would be "nice to have", I would recommend you try to talk whoever wants this out of wanting it. This is a large undertaking so make sure you really need it:
- There will be quite a bit of code to write and maintain. And this code can easily end up scattered through out your application, complicating maintenance. If you are still pretty new to VBA, this could be a bit too much to tackle.
- Although the latest version has made some in-roads towards this functionality, Access wasn''t designed for this as a Desktop Database. Where as SQL Server has easy ways of accomplishing this, being a true multi-user environment.
- You could be generating a considerable amount of data that will never be used.
- Any reliance on Access'' security is misplaced as there is almost always a way around the security.
J绝对正确。
任何合理的高级用户可以绕过访问程序员采取的大部分安全措施。
但是，Allen Browne有一篇相当全面的文章，其中包含我们许多人多年来使用过的代码/示例。 创建审核日志
创建您的前端/后端。
同时保护密码和加密。
保护您的VBA项目并防止在前端查看。
使用前端文件的副本 创建前端 的可执行版本（这不是一个可逆过程，所以请确保你保留一份开发副本！）。
J is absolutely correct.
Any reasonably advanced user can bypass most if not all of the security measures taken by the access programmer.
With that said; however, Allen Browne has a fairly comprehensive article with working code/examples that many of us have used over the years. Creating an Audit Log
Create your front-end/back-end.
Secure both as well as be done with passwords and encryption.
Secure your VBA project and protect from viewing in the front-end.
Create the executable version of your front-end using a copy of the front-end file (this is not a reversible process so make sure you keep a development copy!).
这篇关于跟踪用户对记录所做的更改/编辑。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
