跟踪原始表数据信息的变化 [英] Track changes of raw table data information

问题描述

你好，


注意：我在MS Access 2003中工作，只能获得AC $


好​​吧这可能是奇怪的或不是可能;


我为用户在表单中的操作创建审计跟踪，监视和跟踪从数据库更新/输入/删除的字段，这些操作基本上是从命令按钮（和审计跟踪，按钮点击编码）


但是，我有几个搜索屏幕，返回一个子窗体列出结果。返回的这些数据表有​​效地打开原始表，因此是可编辑的（允许更改权限，因为它们只是管理员搜索，是的，他们可以更改原始表）


如何我可以跟踪对原始表字段的更改，即，如果有人将字段SURNAME从Smth更新为Smith，是否会触发此事（显然如果它在界面文本框中，您可以审核这是他们的一个领域变化。我建议它的唯一方法是创建初始结果的记录集，然后将它与表中的结果进行比较，因为它们将两者进行比较并进行比较。任何想法？


谢谢，


jac

Hello,

NOTE: Im working in MS Access 2003, result in ACcess ONLY please

Ok this might be strange or not possible;

Im creating an audit trail for users actions in a form, to monitor and keep track of what fields were updated/entered/removed from the database, these actions are essentially done from command buttons (and the audit trail, is coded on the button click)

However, I have a few search screens, that return a subform listing results. These datasheets returned are effectivly like opening the raw table and hence are editable, (permission to change is granted as they are admin only searches, yes, they can change the raw table)

How can I track the change to a raw table field, ie, if someone updates the field SURNAME from ''Smth'' to ''Smith'', is there something that triggers this (obviously if it was in an interface textbox, you could audit this) is their a field change. The only way i can suggest it make a recordset of the intial results, then compare that to the results in the table as they leve and compare the two. any ideas?

Thanks,

jac

推荐答案

所有表格，并且无论您如何显示表单，这些表单上的控件都应该具有可以触发的事件。您可以使用这些事件来创建审计跟踪。因此，它不是原始的。数据最严格的定义。我的意思是表格的数据表视图仍然不是原始的。数据。在数据表视图中显示表单并不像在第一篇文章中那样打开表格。


您无法审核原始表格数据最严格的定义。这是直接打开表并编辑数据。


如果您使用的是Access 2010，则可以使用与其他数据库中的触发器类似的数据宏。

All forms, and controls on those forms, regardless of how you display the form, should have events that can trigger. You can use those events to create your audit trail. Therefore, it is not "raw" data in the strictest definition of the word. What I mean is a datasheet view of a form is still not the "raw" data. Displaying a form in datasheet view is not effectively like opening the table as you say in your first post.

You can not audit "raw" data in the strictest definition. That being opening the table directly and editing the data.

If you are using Access 2010, you can use a data macro which is similar to a trigger in other databases.

您是否知道在数据表模式下更新数据时触发的事件Rabbit？

Do you know the event that triggers when data is updated in Datasheet mode Rabbit?

我会假设将触发BeforeUpdate或AfterUpdate事件。我不再拥有2003所以我无法在那个环境中进行测试，但我知道它至少从2007年开始就会触发。

I would assume the BeforeUpdate or AfterUpdate event would trigger. I no longer have 2003 so I can''t test in that environment but I know it triggers at least from 2007 onwards.

这篇关于跟踪原始表数据信息的变化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！