问题描述
嗨 - 我为数据库创建了多个表和表单。我们使用表单将数据输入表中,而表单又链接到交换机上的项目。我希望不同部门的多个用户可以使用表单访问和输入数据。交换机上的项目是为不同的部门创建的,我想用密码保护这些项目,以便各个部门可以访问它们。我不确定密码保护交换机上的每个项目是否合适。请有人帮忙。我是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.
推荐答案
这篇关于保护MS Access中的表中的记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!