How to Setup Auto Logon?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a need to either bypass entering userid/pwd
or assign it permanently in the application so that
users don't have to enter userid/pwd upon logon.
How can I do so? It shouldn't even show the dialog
box for user logon.

Thank you,
-Me
 
the dialog only shows if you have a password associated with your ADMIN
user. Just remove that password.

Rick B
 
Me said:
I have a need to either bypass entering userid/pwd
or assign it permanently in the application so that
users don't have to enter userid/pwd upon logon.
How can I do so? It shouldn't even show the dialog
box for user logon.
Click to expand...

It's difficult to tell whether you want to remove security, or just avoid
the users having to login.

If you have only one level of security needed, you can implement security
that requires no login.

If you still need security, but more than one user group, then you can
create a desktop shortcut that includes the username/password switches:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw" /user "joe" /pwd
"whatever"

Of course, that isn't very secure since anyone can read the properties of
the shortcut.

If you want to remove security altogether, then post back.
 
Joan,

Thank you for your reply!
I just want users to avoid login.
I have query forms linked to the SQL server
database, when they run query for the 1st time after
launching access database it asks for userid/pwd.
How can I avoid that?

I have done in the past, but I forgot now.

-Me
 
Me said:
Thank you for your reply!
I just want users to avoid login.
Click to expand...

I'm sorry but I'm still not clear. Do you no longer want security on the
Access frontend? To remove security, login as a member of the Admins group.
Give full permissions to all objects to the Users Group. Exit Access, and
then reopen it using the standard system.mdw workgroup (you'll get no
login). Create a new mdb and import all objects from your mdb. This new
mdb will be unsecure, and users can open it with their system.mdw with no
login prompt.

If you still want security, then provide them with a desktop shortcut as I
described in the previous answer.

"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw" /user "joe" /pwd
"whatever"
 
You can try with this set of functions: SaveSetting() and GetSetting(). They
write information which You want into Windows registry base. Look for an
example in Access help.
Your users should enter a user name and a password only first time, and
chacked the "remember my password" check box, and after that You should
store userid/pwd combination in registry and next time, when user starts an
application, only thing You should do is to retrive information from
registry.

Vojislav Depalov
 
Back
Top