Suppress or change the very basic login?

[Guest]

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?

 

[Rick Brandt]

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.

 

[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

in message: