|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
call change user passwordI've been using a form built straight out of Microsoft Knowledge Base Article
- 200665 and for the past few months to have users change passwords and it had worked just fine. Recently however, I starting getting a default Microsoft error that reads "There was an error running your request - check that all fields are properly filled in." I've gone back to many archived versions of the form to see if something by accident was changed, but all older versions produce this same result on my development and test systems. I am clueless why this started happening. Any ideas? Thank you That doesn't sound like an error that you should get from running the
code in that article. Are you sure it isn't coming from the code that *calls* that code? The first think I would do, is to comment-out the following statement: On Error GoTo ChangeResetPassword Then, if the error is occuring inside that code, it will stop on the actual line in question, instead of going to the error trap at the end of the code. HTH, TC I am trying to set up a form to allow users to change their own password. I
used the code in Article 200665 and get a compile error message "Ambiguous Name Detected: ChangeUserPassword". I'm not sure of how to call this, can someone help? Show quote "TC" wrote: > That doesn't sound like an error that you should get from running the > code in that article. Are you sure it isn't coming from the code that > *calls* that code? > > The first think I would do, is to comment-out the following statement: > > On Error GoTo ChangeResetPassword > > Then, if the error is occuring inside that code, it will stop on the > actual line in question, instead of going to the error trap at the end > of the code. > > HTH, > TC > > That would imply that there is more than one public procedure called
ChangeUserPassword, in your database. Find the duplicates, see if they are the same, and if so, delete all but one of them. Take a backup of your database first, just in case you muck it up! HTH, TC Sorry for the delay. I did have a "test" module that once deleted removed the
error. Now I get a new permissions error: You don't have the necessary permissions to use the "myobject" object. I am the db owner. Any ideas what I did wrong this time? Thanks! I used: http://support.microsoft.com/default.aspx?scid=kb;en-us;200665 to set up the form - frmChangePasswords and the module SecurityCode. Show quote "TC" wrote: > That would imply that there is more than one public procedure called > ChangeUserPassword, in your database. > > Find the duplicates, see if they are the same, and if so, delete all > but one of them. > > Take a backup of your database first, just in case you muck it up! > > HTH, > TC > > Hello again, I logged out and back into the database and found that my
password actually did change, even though I received the error message. I'll look at the Err code. Thanks, Mary Show quote "Mary" wrote: > Sorry for the delay. I did have a "test" module that once deleted removed the > error. > > Now I get a new permissions error: You don't have the necessary permissions > to use the "myobject" object. > > I am the db owner. > > Any ideas what I did wrong this time? Thanks! > > I used: http://support.microsoft.com/default.aspx?scid=kb;en-us;200665 to > set up the form - frmChangePasswords and the module SecurityCode. > > > > > "TC" wrote: > > > That would imply that there is more than one public procedure called > > ChangeUserPassword, in your database. > > > > Find the duplicates, see if they are the same, and if so, delete all > > but one of them. > > > > Take a backup of your database first, just in case you muck it up! > > > > HTH, > > TC > > > > Got it working - thanks for your help!
Show quote "Mary" wrote: > Sorry for the delay. I did have a "test" module that once deleted removed the > error. > > Now I get a new permissions error: You don't have the necessary permissions > to use the "myobject" object. > > I am the db owner. > > Any ideas what I did wrong this time? Thanks! > > I used: http://support.microsoft.com/default.aspx?scid=kb;en-us;200665 to > set up the form - frmChangePasswords and the module SecurityCode. > > > > > "TC" wrote: > > > That would imply that there is more than one public procedure called > > ChangeUserPassword, in your database. > > > > Find the duplicates, see if they are the same, and if so, delete all > > but one of them. > > > > Take a backup of your database first, just in case you muck it up! > > > > HTH, > > TC > > > > "Mary" <M***@discussions.microsoft.com> wrote in message The module should not have the same name as the sub. That may be the cause.news:A3CFCB23-767C-4C5F-BFC2-36DCD6BD41ED@microsoft.com... >I am trying to set up a form to allow users to change their own password. >I > used the code in Article 200665 and get a compile error message "Ambiguous > Name Detected: ChangeUserPassword". I'm not sure of how to call this, can > someone help? -- Joan Wild Microsoft Access MVP  |
|||||||||||||||||||||||
Other interesting topics