保护MS Access中的表中的记录 [英] protect records in tables in MS Access

问题描述

嗨 - 我为数据库创建了多个表和表单。我们使用表单将数据输入表中，而表单又链接到交换机上的项目。我希望不同部门的多个用户可以使用表单访问和输入数据。交换机上的项目是为不同的部门创建的，我想用密码保护这些项目，以便各个部门可以访问它们。我不确定密码保护交换机上的每个项目是否合适。请有人帮忙。我是MS Access 2007或任何数据库管理程序的新手。


此外，我们如何保护表中的记录不被某人删除。


提前谢谢。

Hi - I have created multiple tables and forms for a database. We are entering data into the tables using forms which in turn are linked to items on a switchboard. I would like multiple users in different departments to have access and enter data using the forms. The items on the switchboards are created for different departments and I would like to password protect each of these items so that it is accessible by respective depts. I am not sure if it is poosible to password protect each item on a switchboard. Could someone please help. I am new to MS Access 2007 or any database management programs.

Also, how can we protect a record in the table from getting deleted by somebody.

Thanks in advance.

推荐答案

我不知道有什么方法可以使用内置的交换机进行此操作我从不使用它，因为我构建了所有自己的菜单，这使得我可以在构建时将任何附加功能设置到按钮后面的代码中。

I am not aware of any way of doing this with the built in switchboard but then I never use it as I build all my own menus which allows me to set any extras into the code behind the buttons as I build.

欢迎来到Bytes！


关于保护个人记录不被删除的问题，Access不是为了提供记录级访问权限而设计的。使用SQL Server和其他客户端 - 服务器后端数据库，用户访问权限有很多选择，但Access不是很遗憾，我很遗憾地说。您必须自己实现用户级安全措施 - 没有自动方法，并且在Access 2007中，早期版本的Access中提供的有限安全功能已停止。


同样，要使用定制的交换机，您需要提供自定义用户安全性，编程为不同用户提供不同的表格视图等。


一种方法是通过使用自定义函数来检索单个用户以检索其网络登录ID或用户名，并在打开数据库时使用当前用户的网络ID来确定您存储在数据库中的数据的权限和其他设置。您需要维护和管理的自定义用户表。


我没有通过自动方式完成所有这些工作，因为Access根本没有内置功能来处理这种定制的安全性。


-Stewart

Hi, and Welcome to Bytes!

On your concerns about protecting individual records from deletion, Access is not designed to provide record-level access rights. With SQL Server and other client-server back-end databases there are many choices for user access rights, but not with Access I''m sorry to say. You would have to implement user-level security measures yourself - there is no automatic way to do so, and in Access 2007 the limited security features that had been available in earlier versions of Access were discontinued.

Similarly, to use bespoke switchboards you will need to have custom user security available, programmed to offer different users different views of the forms etc.

One approach is to identify individual users by using custom functions to retrieve their network log-in IDs or user names, and on opening the database use the network ID of the current user to determine permissions and other settings from data you store in a custom user table which you will need to maintain and administer.

There is no automated way I know of to do all this, as Access simply does not have built-in features for handling such bespoke security.

-Stewart

您可以''排序''密码保护每个交换机选项。只需将Switchboard Items调用公共功能，即可在其中包含密码功能。如果用户通过测试，代码将通过，如果不是，您只需退出功能。

You can ''sort of'' Password Protect every Switchboard Option. Simply have the Switchboard Items call Public Functions within which Password functionality can be incorporated. If the User passes the test, the code will fall through, if not you can simply Exit the Function.

这篇关于保护MS Access中的表中的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！