Access 2003安全性 [英] Access 2003 Security
问题描述
这里的新用户。
我已经构建了一个数据库来跟踪基本的员工信息。
我希望将完成的数据库放在网络上。
我需要显然保留数据库各方面的完全管理员权限。
更重要的是，我需要允许一位文书用户输入数据，就是这样。
现在......我已经通过各种解释如何设置它，但没有一个对我有意义。
即使是Access 2003安全向导也很棒，但是......我很明显遗失了什么。
有没有人有如何做到这一点的非专业版？
提前谢谢。
< blockquote>从工具/安全性中可以选择设置用户;组以及为每个对象（查询;表;等）分配对所述用户和/或组的权限。
设置< New ...的权限很重要>每个列表中的项目 - 这样可以节省您在创建新对象后转移并设置权限的麻烦。
NB。非常重要的是要知道。
默认情况下，Access设置为使用用户管理员作为标准而无需密码。
如果你想控制安全性，你必须应用你的用户安全数据库（通常为SYSTEM.MDW）给将使用您的项目的所有用户。这是使用工作组管理员完成的。我担心这一切都不是管理员友好的。您可以删除管理员帐户或应用密码。但请记住，精明的用户会知道在不知道密码的情况下使用管理员帐户只需要使用默认值替换SYSTEM.MDW。有很多要记住，坦率地说，没那么有趣 - 但你确实要求......
检查这个网站。这是非常好的。
http：// www .jmwild.com / Accesssecurity.htm
New user here.
I have constructed a database to track basic employee information.
I wish to place finished database on a the network.
I need to obviously retain full admin persmissions for all aspects of the database.
More importantly I need to allow one clerical user to enter data and thats it.
Now...I have been through various explanations of how to set this up but none of it is making sense to me.
Even the Access 2003 security wizard is great, but...I am obviously missing something.
Does anyone have a laymans version of how to do this?
Thanks in advance.
From Tools / Security there are options to set up Users; Groups and also to assign permissions for each object (query; table; etc.) to said users and / or groups.
It''s important to set the permissions on the <New ...> item in each list - as this will save you the trouble of going around afterwards and setting the permissions after you''ve created a new object.
NB. Very important to know.
By default, Access is set up to use the user Admin as standard without a password.
If you want to control the security you must apply your user security database (normally SYSTEM.MDW) to all users who will be using your project. This is done using the ''Workgroup Administrator''. I''m afraid none of this is very Administrator friendly. You can remove the Admin account or apply a password. Bear in mind though, a canny user will know that to use the Admin account without knowing the password simply involves replacing your SYSTEM.MDW with the default. Lots to bear in mind and, frankly, not much fun - but you did ask...
Check this website out. It''s very good.
http://www.jmwild.com/Accesssecurity.htm
这篇关于Access 2003安全性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
