Workgroup Security/Electronic Signature (PW *after* logon)

[Michelle]

I have a db (Access 2002) that I have applied workgroup security to. Users
login initially with their username and password. Once in the db, I can call
their logon with the [CurrentUser] function, but I also need to require a
password for data entry (e.g., when a record is added, the user must
correctly enter their password again, even though they are already logged
in.) Is this possible?

 

[jacksonmacd]

I have a db (Access 2002) that I have applied workgroup security to. Users
login initially with their username and password. Once in the db, I can call
their logon with the [CurrentUser] function, but I also need to require a
password for data entry (e.g., when a record is added, the user must
correctly enter their password again, even though they are already logged
in.) Is this possible?

It's possible, but what would it accomplish? Sounds a bit redundant to
me.

Anyway, you could design your form with the AllowEdits property to set
to False. Upon initiating the edit, you could detect the current value
of the AllowEdits property, and initiate a login procedure if it was
found to be false.

Create a DAO workspace object, and login using the CurrentUser()
function and the password as supplied by the user. If the login to the
workspace is successful, then set the AllowEdits of the form to True.

As I said, seems like a lot of work for no apparent benefit.