SQL更新用户密码 [英] SQL to Update User Password
问题描述
首先，这是我的第一篇文章，所以我希望不要把它弄得太糟糕。我正在为访问数据库设置一个简单的登录。数据库保留在安全的内部服务器上，登录只是为了防止其他员工篡改数据库中的数据。通过研究和测试，我能够让它运作起来。但是，当它处理密码更改时，会出现一个提示，重新输入用户名。我有一个功能设置（UserNameWindows）来获取员工的Windows用户名，并使用它作为他们的登录ID。我的问题是，我的SQL语句是否有问题导致它验证;还是我只是遗漏了什么？我的假设是我的''WHERE'部分的SQL语句不完整或不正确。
First of all, this is my first post so I am hoping not to screw it up too bad. I am working on setting up a simple login for an access database. The database is retained on a secure internal server, the login is just to help keep other employees from tampering with the data in the database. Through research and testing it out, I was able to get it working. However, when it processes the password change, a prompt appears to re-type in the username. I have a function setup (UserNameWindows) to get the Windows Username of the employee and am using that as their login ID. My question is, is there something wrong with my SQL statement causing it to verify; or am I simply missing something? My assumption is my ''WHERE'' section of the SQL statement is incomplete or incorrect.
推荐答案
当你已经在使用Windows域帐户并允许它保存密码时，我很难理解为什么你需要数据中的帐户或密码信息。
但是，如果您的代码无法满足您的要求，无论您有何要求，如果您能解释其中的行踪，我们将帮助您。代码它给出了这个提示以及为什么你觉得它不应该是它应该做什么。
I''m struggling to see why you need account or password information in the data when you are already using the Windows domain account and allowing it to maintain the password.
However, if your code is failing to do what you require, regardless of why you have that requirement, it would help us to help you if you can explain whereabouts in the code it gives this prompt and why you feel it''s not what it should be doing.
我也很困惑为什么你想要做所有这些，但我有一个感觉你的错误是由于缺少Me.txtLoginID.Value
I''m also confused why you would want to do all this, but I have a feeling your error is being caused by missing quotes around the value ofMe.txtLoginID.Value
首先，感谢您的回复。需要登录的原因是是因为每个有权访问共享网络驱动器的人都可以访问数据库;但是只有大约20个人需要使用它甚至看它。在发生某些事情之前，我试图采取积极主动的措施，阻止一些可能对数据库感到厌倦并开始改变信息的员工。我有一个审计跟踪设置，所以我将能够告诉谁正在进行更改;但如果可能的话，宁可避免这样做。我意识到这可能不是最安全的。我对Access VBA相当新手，并在一些线程上读取添加密码登录是一个简单的路径。它不是活的现在，仍处于开发阶段，正在开发更可行的选项。
jforbes，我添加了这些引号，解决了我的问题，不再提示验证UserName。我感兴趣的是在用户表中添加了标志或整数。我将做一些研究并尝试将其构建到数据库中，这似乎是一个更好的选择。感谢您提供的那条信息。
First of all, thank you for the responses. The reason for the need to "login" would be because everyone who has access to the shared network drive has access to the database; however only about 20 people need to use it or even look at it. I was trying to be proactive before something happened by stopping some of the employees that may wonder into the database out of boredom and start changing information. I have an audit trail setup, so I will be able to tell who is making changes; but would rather avoid that if possible. I realize this may not be the most secure. I am fairly novice with Access VBA and read on some threads adding a password login is a simple route to take. It is not "live" right now, still in development and working on more viable options.
jforbes, I added those quotes and that resolved my issue and am no longer prompted to verify the UserName. I am interested in the addition of flags or integer to the User Table. I will do some research and attempt to build that into the database, it seems like a better option. Thanks for that piece of information.
这篇关于SQL更新用户密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
