多用户登录/限制 [英] Multi User Login/Restrictions

问题描述

我正在为团队创建数据库。在这里工作。需要与此数据库合并的一件事是每个用户都有一个登录和密码，我知道如何做到这一点。


我不确定的是，我需要团队负责人。在登录时访问报告和不同的表单。其他用户不应该有权访问这些项目。


是否可以在访问时分配用户权限？

I am in the process of creating a database for a "Team" here at work. One thing that needs to be incorporated with this database is each user will have a log in and password I know how to do that.

What I am not sure of is, I need the "Team Lead" to have Access to reports and different forms when he logs in. The other users should not have access to these items.

Is it possible to assign user permission in access?

推荐答案

是否可以在访问中分配用户权限？

Is it possible to assign user permission in access?

是的。最简单的方法是为组分配/拒绝特定的对象权限，而不是用户，然后专门将用户放入适当的组。预先警告，这是一个非常混乱且相当复杂的过程，需要您花费大量时间和精力。请务必保存原始工作组信息文件（WIF）！

Yes it is. The easiest approach would be to assign/deny specific Object Permissions to Groups, not Users, then specifically place Users into the appropriate Group. Be forewarned that this is a very confusing and fairly complex process that will take a lot of time and effort on your part. Be sure to save the original Workgroup Information File (WIF)!

呵呵我刚刚从头开始创建登录。我花了大约10个小时才完成它（现在它需要大约4个小时，因为我现在知道该做什么），我觉得它是一个安全的登录，因为你可以访问。基本上我所做的是创建一个在启动时打开的登录表单，当用户登录时，我将所有该人的数据（名称，电子邮件，权限，您需要了解的有关用户）存储到隐藏表单中被称为frmCookies。它一直运行，直到用户注销，然后关闭此表单。如果有人试图在没有先登录的情况下打开ANYTHING，我会设置停用。如果没有cookie，则登录关闭数据库的事件 - 如果他们没有正确输入用户名和密码，则完全锁定数据库中的任何人（包括我发现的！）。坦率地说，如果我只是将文件转换为.accde或（.mde，如果你没有访问2007）格式，那就不需要了，但如果你想让某些用户进行设计更改并在主要访问程序。如果你对如何设置一个有任何进一步的问题，请务必告诉我。


现在，我不是故意劫持你的线程，但是因为它'' s相关（你可能会感兴趣）我仍然在努力弄清楚如何让它在一段时间后自动注销用户。如果有人有任何想法，请发布它们！

hehe i just finished creating a login from scratch. it took me about 10hrs to do it (now it would take me about 4hrs since i now know exactly what to do), and i feel like it is as secure of a login as you can get with access. basically what i did was create a login form that opened on startup and upon the user logging in, i stored all of that person''s data (name, email, permissions, whatever you need to know about the user) into a hidden form called "frmCookies." it runs at all times until the user logs out and then this form is closed. and if anyone tries to open ANYTHING without logging in first, i set the "deactivate" event of the login to close the database if there were no cookies in place--completely locking anyone (myself included i found out!) out of the database if they haven''t entered in their username and password correctly first. frankly, that wouldn''t have been needed if i just converted the file to a .accde or (.mde if u dont have access 2007) format but it makes sense if you want certain users to make design changes and build queries in the main access program. if u have any further questions on how to set one up, make sure to pm me.

now, i don''t mean to hijack your thread here, but since it''s related (and you would probably be interested as well) i''m still working on trying to figure out how to have it automatically logout a user after a set amount of time. if anyone has any ideas please post them!

现在，我不是故意劫持你的线程，但由于它是相关的（你可能也会感兴趣）我仍然在努力弄清楚如何让它在一段时间后自动注销用户。如果有人有任何想法请发布！

now, i don''t mean to hijack your thread here, but since it''s related (and you would probably be interested as well) i''m still working on trying to figure out how to have it automatically logout a user after a set amount of time. if anyone has any ideas please post them!

没问题，可以在这里提出更多问题，因为我会从你提出的问题中学习，你会得到我所说的那些问题的答案问。

No problem at all feel free to ask more questions in here because i''ll learn from the questions your asking and you will get answers to the ones i''m asking.

这篇关于多用户登录/限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！