锁定某些记录的最佳方法 [英] Best way to lock certain records from being edited
问题描述
大家好,
Hello everyone,
我们使用Access数据库来跟踪销售,采购,发货等情况。所有数据都是通过表格输入的。
We use an Access database to track sales, purchases, shipments and so on. All of the data is entered via forms.
我想知道锁定某些记录是否被意外编辑的最佳方法是什么。这必须是常见做法,我想知道是否有标准功能或财产这样做。
I am wondering what the best way is to lock certain records from being accidentally edited. This must be common practice, and I was wondering if there was a standard function or property to do so.
例如,对于采购订单:员工输入采购订单信息。一旦供应商向我们发送发票,管理层就会进入并验证产品和发票。发票上的总数与我们数据库中输入的内容相匹配。如果它是
,我希望管理层能够点击按钮并有效地锁定此特定采购订单。
For example, for purchase orders: The purchase order information is entered by the employee. Once the supplier sends us the invoice, management goes in and validates that the products & total on the invoice match what was entered in our database. If it does, I would want management to be able to click a button and effectively lock this specific purchase order from being edited.
感谢您的帮助!
推荐答案
这必须是常见做法,我想知道是否有标准函数或属性这样做。
This must be common practice, and I was wondering if there was a standard function or property to do so.
您好SL02,
我处理这些事情的方式如下:
The way I handle these things is as follows:
连续表格(例如来自对订单的查询)原则上是不可编辑的。
Continuous forms (e.g. from a query on Orders) are in principle not editable.
通过可编辑的"新"订单输入新订单。形成。
New orders are entered through an editable "New" form.
要更改现有订单,请打开"单个"按钮。表单,您可以根据授权级别编辑字段。取决于 - 再次授权 - 以及订单记录中某些字段的值,"单个"的可编辑性。禁止使用
表格。 ApprovalDate可能就是这样一个领域。要删除ApprovalDate,您需要更高的授权级别。
To change an existing Order you open a "Single" form, where you can - depending on authorization level - edit fields. Depending - again authorization - and the value of certain fields in the Order record, the editability of the "Single" form is prohibited. An ApprovalDate could be such a field. To remove an ApprovalDate you need a higher authorization level.
这种工作方式现在是我所有应用程序的标准。
This way of working is now standard for all my applications.
仔细考虑。
Imb。
这篇关于锁定某些记录的最佳方法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!