re-enter password for table

[jenhow]

Here is my scenario:

Jane and Dan share a computer. Jane logs into the Access database using her
password. She leaves her desk and Dan uses the database to mark that he did a
certain task. However, since Jane is logged in, the records indicate that
Jane performed this task.

The database is password protected using a security file with each user's id
and password.

I have given users a lecture on logging off, but is there a way to make them
re-enter their password when they mark this particular task to ensure that
the person who is logged in is the person performing the task?

 

[Tom van Stiphout]

On Mon, 17 Sep 2007 14:02:24 -0700, jenhow

Yes. You could pop up a modal dialog to prompt for the password
(input mask = password), then call CreateWorkspace with the current
user and that password and see if it works.

You can also auto-logout your app. There is a MSFT knowledge base
article about it. Be warned that the suggested code only works in
ideal circumstances.

-Tom.