在ms访问的同时，使用单个用户名限制多个登录 [英] Restrict multiple logins with single username at sametime in ms access

问题描述

大家好


我有一个带有登录名和密码形式的mdb。有几个登录名，我通过表User_login定义。这里的问题是单个用户能够在多个系统中登录，我想限制。


这里是用于登录检查的代码... ..

Hi all

I have a mdb with login name and password form. There are several login names, i defined through a table "User_login". Here the problem is at a time a single user is able to login in multible system, which i want to restrict.

here is the code which i i am using for login check.....

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

推荐答案

你不会说：

你遇到了什么问题。

你得到了什么错误信息。

错误信息在哪一行。

You don''t say :
What problem you''re having.
What error messages you''re getting.
What line the error message is on.

假设[cmbName]包含字符串值，请尝试将代码的第26行更改为：

Assuming [cmbName] holds a string value, try changing line #26 of your code to :

展开 | 选择 | Wrap | 行号

要确保同一用户一次只登录一次，请在[User_Login]表中添加一个字段，指示用户是否目前已登录。成功登录后需要将其设置为TRUE，并在检查名称和密码时对其进行测试。


您还需要重置设施系统在任何时候崩溃的任何或所有名称。

To ensure the same user only logs in once at a time, add a field into your [User_Login] table that indicates if the user is currently logged in. You will need to set it to TRUE after a successful login, and test for that too when checking the name and password.

You will also need a facility to reset any or all names in case the system crashes at any point.

这篇关于在ms访问的同时，使用单个用户名限制多个登录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！