Hi Everyone,


I am interested in building some security features to lockout customers for non payment of software support. Basically when i receive their monthly payment I give them their pass-code for the following month.

I am envisioning making a password table that would have a password column with monthly predefined codes, A predefined date column, and their password column.

I would then make a parameter query from the password table for the customer to put in the pass-code. Then make a form from the query and add a clock that runs off the system time, then i hope to put a nested iif statement in the form to say something like if the two pass-codes are equal and the dates are O.K. open the form if not don't.



Well "that's it folks" any comments or suggestions would be appreciated...