I think I've worked out for myself. There's no need for a password re-check - I just need to check that 'currentuser() is a member of the 'accounts' group.
Thanks guys - It helped putting on it paper!
Jane
--- In MS_Access_Professionals@yahoogroups.com, "Jane" <jcross@...> wrote:
>
> Hi
> I'm using access 2003 & have implemented user-level security & it's working fine.
> Before an order is despatched the customer's credit limit is checked & the order is stopped if they are over the limit.
>
> I'd like to add an button for someone in the accounts department to be able to over-ride this stop if required, by re-entering their login password (just to save having to have another password). It will open a form asking for their password. I can get their username from currentUser(), but is there anyway of checking that the password they enter is correct for that user?
>
> Many thanks
> Jane
>
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar