By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,226 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,226 IT Pros & Developers. It's quick & easy.

Access 2003 Update query help

P: 3
I am trying to get an update query to change the password when run.
At the moment I have the two fields;
- Password
- Change_password

I want the query to update my table when the user had written in both of the two fields which should overwrite the previous password with the 'change_password' field.

Any help would be much appreciated.
Nov 16 '11 #1
Share this Question
Share on Google+
7 Replies

Expert Mod 10K+
P: 12,421
What do you have so far?
Nov 16 '11 #2

P: 3

I have these two fields but am unsure of what I should write to allow the passwords to change.

As at the moment it doesn't edit any of the fields.
Nov 16 '11 #3

Expert Mod 15k+
P: 31,707
Update To: under Password should be set to [Insert New Password].

The whole field [New Password] makes no sense in this scenario as explained and should probably be removed.

Criteria: (underneath Update To:) should be applied to ensure that only the record for a specified user is changed, otherwise all records will be set to the same new password. I doubt this is what you want (You certainly haven't said so in your question).
Nov 17 '11 #4

P: 111
I am having trouble understanding what it is you are trying to accomplish. Maybe if you can explain the nature of what it is you are trying to do then I can grasp it better and throw some suggestions in. Is this for users of a database? Stuff like that.

Nov 17 '11 #5

P: 3
I am trying to update a password, in my members table to a new updated one.
However i have two tables, one which is the proper members table and another which only has the password and username fields.
So this query will be accompanied by another. This one will insert a new password into the second field which the second query will move the new password into the main members table.

The query will hopefully allow a user to change their password of which they use to login.

Sorry for not being clear the first time.
Nov 17 '11 #6

P: 111
No problem. Sometimes its just easier to understand when you know the goal in mind.

What are the names of the tables that you have? What are the names of the fields you have in each table?

Nov 17 '11 #7

Expert Mod 15k+
P: 31,707
The change in design (or explanation of said design) adds far more questions than answers I'm afraid Zak.

Not least why you have such a design, but more importantly the questions already raised (such as how an individual is managed without updating the records for all users) is not even touched on.

Frankly, this is barely a hint of a question. If you want proper help then you'll need to post a properly considered and fully explained question for us to look at. This isn't even close to that - especially now after a whole bunch of new cans of worms have been opened up.
Nov 17 '11 #8

Post your reply

Sign in to post your reply or Sign up for a free account.