prompt for another user's username / password in VBA

[dogatemycomputer]

Greetings,

I am doing the finishing touches on a kiosk application that needs to
be done tomorrow. The last step in the process is to add a security
prompt so the close button on a particular window asks for a
username / password of a user in the "DataEntry" group. If the
username / password does not authenticate then the window should not
close.

The database is using User Level Security. I honesty thought there
would be volumes written on this topic but most of it seems to center
around AD.

Is there a way to hash a password and attempt to authenticate it with
the system.mdw?

Thanks!
Dave

 

[a a r o n . k e m p f]

using SQL Server, you can easily 'runas' the permissions of another
user

 

[a a r o n . k e m p f]

and btw, you know that ULS wasn't added to Access 2007 because it was
too buggy for real world usage right?

Why not just use SQL Server-- if you care enough to build a database--
build it nice, instead of build it twice

SQL Server is _EASIER_ development than MS Access crapware

 

[BruceM]

In case you didn't already know it, ignore the bitter and ignorant troll
Aaron. He is wrong about almost everything, including that User Level
Security was removed from Access 2007. It is not buggy; it just does not
provide a very high level of security. Some locks are easier to break into
than others. That is not a comment on the locks, but rather on their
application. You can expect a sophomoric (if I am not giving him too much
credit) response to what I have written.

I responded because of Aaron's meddlesome reply. In specific reply to your
question, I cannot think of a way to invoke the original logon dialog (which
is not to say for sure that there is no way), but since all you are trying
to do, it seems, is prevent accidentally closing the database, maybe this
can be adapted:
http://support.microsoft.com/default.aspx?scid=kb;en-us;179371

Another option is that you could use the double-click option of an
unattached label, or something of the sort that is unlikely to be done in
the usual course of using the database, to make the Close button appear.
The code in the link could be used after clicking the Close button.

You could also just have the Close button open a pop-up form that asks for a
password or two. Password information could be hard-coded into a command
button on the form, or it could be a table look-up. In any case, if the
password matches, allow the Close button code to run; otherwise, cancel the
Close sub.

 

[a a r o n . k e m p f]

wow.. so if a security system is easy to break into-- that doesn't
make it BUGGY?

what planet do you come from?

seriously

ULS was removed from Access 2007 (format)
Replication was removed from Access 2007 (format).

thanks

-Aaron

 

[BruceM]

Interior doors sometimes have what is known as a privacy lockset. That's
one of those locksets that allows somebody to lock the door, but that can be
opened with a nail or some such. By your definition, the lockset is buggy
because it can be opened with little trouble. For that matter, some
security locks are easier to break into than others. Does that make them
buggy?

Maybe security needs depend on the situation. Maybe there's a reason more
effort goes into securing a bank than a gymnasium; more effort into securing
the front door than the bathroom.

Maybe there is a database server with higher security than SQL Server, the
object of your fawning devotion. If so, SQL Server is buggy because it is
easier to break into than that system. Is that how it works?

I will continue to refute your misinformation and lies as needed, but I am
getting bored with your incapacity for logic. Amuse yourself if you must
with an irrelevant, sputtering reply, but don't look for a response.


message
wow.. so if a security system is easy to break into-- that doesn't
make it BUGGY?

what planet do you come from?

seriously

ULS was removed from Access 2007 (format)
Replication was removed from Access 2007 (format).

thanks

-Aaron

 

[a a r o n . k e m p f]

dude you come up with the _WORST_ analogies.. let me guess, you're not
a native speaker?

 

[So Sorry For Poor Aaron]

dude you come up with the _WORST_ analogies.
let me guess, you're not a native speaker?

No, indeed, BruceM does not come up with the "_WORST_ analogies", or the
"_WORST_ replies" or the "_WORST_ logic"... those honors are reserved for
you. You, aaron kempf, are the microsoft.public.access' "King of WORST".

Let us guess, you're not a native thinker?

So Sorry...

 

[a a r o n . k e m p f]

re:
Interior doors sometimes have what is known as a privacy lockset.

IT IS NOT AN INTERIOR DOOR-- IT IS THE ONLY DOOR

ULS IS TOO BUGGY SO IT GOT REMOVED. THAT IS SIMPLE