re-enter password for table

17 Sep 2007 9:02 PM

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?

18 Sep 2007 3:17 AM

Tom van Stiphout

On Mon, 17 Sep 2007 14:02:24 -0700, jenhow
<jen***@discussions.microsoft.com> wrote:

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.

Show quote

>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?
>