Home All Groups Group Topic Archive Search About

Suppress or change the very basic login?

Author
17 Oct 2006 7:52 PM
jonefer
Is it possible to either suppress or change MS Access standard login for
secured databases?

I'd like to either create my own login form where I can prompt the user to
create a password --- OR

manage multiple users by just adding them to a table that checks for their
userid in wndows authentication... has anyone ever done this?

Author
17 Oct 2006 8:00 PM
Rick Brandt
jonefer wrote:
> Is it possible to either suppress or change MS Access standard login
> for secured databases?
>
> I'd like to either create my own login form where I can prompt the
> user to create a password --- OR
>
> manage multiple users by just adding them to a table that checks for
> their userid in wndows authentication... has anyone ever done this?

Access security is "set" before your file is ever opened so you cannot run
any code to support a custom login.  The "session" is what has the security
profile, not the file being opened.

You could use a table of network logins to provide "friendly guidance", but
it would offer no real security.  If that is all you need then it would work
without having to implement Access Security at all.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com
Author
17 Oct 2006 8:25 PM
Jeff Conrad
See this page for a possible work-around:

http://www.access.qbuilt.com/html/custom_login.html

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

"jonefer" wrote in message:
Show quoteHide quote
news:90228D11-FBAA-4684-AD2E-EA85030955CB@microsoft.com...

> Is it possible to either suppress or change MS Access standard login for
> secured databases?
>
> I'd like to either create my own login form where I can prompt the user to
> create a password --- OR
>
> manage multiple users by just adding them to a table that checks for their
> userid in wndows authentication... has anyone ever done this?