我可以使用密码保护单个表吗？ [英] Can I secure a single table with a password?

问题描述

我有一个需要保护的访问表。它将在文件共享上，只有能够看到信息的人才能访问，我只想在编辑功能上输入密码。这可以针对单个表而不是用户特定而是密码特定的吗？

I''ve got an access table that I need to be secured. It will be on a fileshare that only people that can see the information will be able to access, I simply want to put a password on editing capabilities. Can this be done for a single table without having it be user specific but rather password specific?

推荐答案

我'我有一个需要保护的访问表。它将在文件共享上，只有能够看到信息的人才能访问，我只想在编辑功能上输入密码。这可以针对单个表进行，而不是用户特定的，而是密码特定的吗？

I''ve got an access table that I need to be secured. It will be on a fileshare that only people that can see the information will be able to access, I simply want to put a password on editing capabilities. Can this be done for a single table without having it be user specific but rather password specific?

我不相信您可以提供允许编辑Access数据库中特定表的密码。如何创建组并仅允许此组独占访问此表而不允许其他组。然后，您可以将适当的用户添加到此组。

I do not believe that you can supply a Password that will allow editing of a specific Table in an Access Database. How about creating a Group and allow only this Group exclusive access to this Table and no others. You would then add the appropriate Users to this Group.

抱歉，Access表始终是不受保护的。当一个用户可以看到他可以操作它的表..

当你的用户只安装了Access运行时而没有来自Access的副本时，你就可以控制表了因此，用户只能使用您构建的表单，并且无法直接打开表格。

如果他们有完全安装的副本，那么您唯一的机会就是安装MS SQL或支持存储过程和触发器的另一个数据库。


Nic; o）

Sorry, but Access tables are always "unprotected" when a use can see the table (s)he can manipulate it..
When your users have only the Access runtime installed and no copy from Access themselves, you''ll be able to control the table as such users can only work with the form''s you build and can''t get the tables opened directly.
When they have a fully installed copy, then your only chance is to install MS SQL or another database supporting stored procedures and triggers.

Nic;o)

没关系，但因为我的大部分代码都是通过使用模块来完成的，我可以参考另一个受密码保护的数据库。或者我只是将信息放在另一个访问数据库中，并将其放入新的临时表中，我想。

okay but since most of my code is done through the use of modules, I could make reference to another database that is password protected I guess. Or I''ll just put the information in another access database and have it pulled into a temporary table in the new one, I guess.

这篇关于我可以使用密码保护单个表吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！