Changing a Variable at Run time.

[SDS100UK]

Hi,
Is it possible to change permanently the value of a variable at run time?
I have a password form and the passwords are stored as variables. I want the user to be able to change their own password, thus they will need to change the value of the variable. I have an unbound text box which is compared against the variable.

Is there a better way of having a password form?

Thanks

Steven

 

[jgoodman00]

Ideally you would have a table containing these usernames & passwords. That way, when a user changes their username it is simple to get this to update the underlying table & thus permanently change their password.

Another way of doing this is to use the inbuilt security which is part of access & allows you to setup users & administrators. This is also a more secure way of doing it, because users & passwords are never actually stored as tables which someone could read......


hth James Goodman
j.goodman00@btinternet.com