Update query to update filds with password

  • Thread starter Thread starter newbie
  • Start date Start date
N

newbie

Hi,
I'm triyng to update the password field in a user table
with a random password provided by a user function called
SecPwd.
I'm getting the same password in all the records in that table.
How do I get access to place a different password in each
record?
 
Well, it depends on the function and how you're calling it. What is the VB
source for the function? How are you using it? In an Update query?

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Wifi Network Issue 0
Update Query Randomization 6
update query 2
Complex Query Question 2
masking data in password field in resulting query 4
Expiration notification 4
Not a valid password error 2
Access Updating inventory levels 0

Back
Top