Multiple Passwords to access form with query!

[themanof83]

Ok guys here is the challenge!!

I have a table which lists a number of programmes, each program has a password field along with other fields.
Basically, when the switchboard is open I want the user to select a programme and then enter a password associated with that programme. Popping up with the relevant messages if the password is incorrect etc.
I then would like the selected information from the programme table to be used to open a form with only information displayed for the specific programme.

I have created a form for the programme selection and password phase which opens when you open the switchboard and I have tried to impliment the standard Microsoft form password protection as detailed in Article ID 209871. But can't quiet get it to work since I have more than one password and I don't want to use the primary key in this function.

Does anybody know how to modify this so that it works for the above situation, and carry out the above query? Or does anybody have another approach I could take. Any help will be much appreciated.

Thanx in advance.

 

[DCrake]

Simple Software Solutions

Something to think about...

Lets say you accomplish this task, and as you say the user enters a password related to a specific programme, what happens if a user has acces rights to several programmes? They will have to return to the switchboard and log off and log on again to enter a new password for a different program. Not user freindly at all.

You need to consider user rights before you move on to program rights.

CodeMaster:

 

[themanof83]

Re:

Very good question, and it is true that people will have access to multiple programs but work will be carried out primarily on a single program in a long period of time. There will be a seperate database (essentially a copy) but without the password form enabled, thus allowing an Admin to view all the records of all programmes.

Do you have any suggestions to get around this anyway?

 

[gemma-the-husky]

are you using a standard access switchboard

if so add another column to the switchboard items table called password, and store the password in there (encrypt/decrypt with simple code if you think users might see it directly - decrypt/encrypt a char at a time with xor is the easiest way. xor a byte once, its encrypted, xor again its back to the original value- normal users wont be able to unravel that)

then if they need a password, just popup an input box to get the password. if its wrong, dont open the form. You have ot modify the switchboard manager code slightly, but that isnt hard

the only slight issue with this is that you cant set input box strings as "masked", password style. If thats an issue you will have to design your own inputbox form to read the password