469,085 Members | 1,045 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,085 developers. It's quick & easy.

Prevent two people from signing in at same time using the same logininfo?

this is probably very simple but I don't know. Is there a way to
prevent two people from signing
on to an Access Application using the some login information????

I can't have two people on the application at the same time with the
same user name. I use currentuser for some locking and filtering.

Thanks for any help.

ray
Dec 4 '07 #1
4 1493
"eighthman11" <rd******@nooter.comwrote in message
news:b5**********************************@w28g2000 hsf.googlegroups.com...
this is probably very simple but I don't know. Is there a way to
prevent two people from signing
on to an Access Application using the some login information????

I can't have two people on the application at the same time with the
same user name. I use currentuser for some locking and filtering.

Thanks for any help.

ray
Two suggestions:
1. Provide a unique username/password to each user and tell them not to
share.
or
2. Create a table and store the field CurrentUser() as each person logs in.
Then delete the record when they exit the database. If the record already
exists when somebody logs in, then give them a msg and docmd.quit

Fred Zuckerman
Dec 4 '07 #2

"Fred Zuckerman" <Zu********@sbcglobal.netschreef in bericht news:Es******************@newssvr13.news.prodigy.n et...
"eighthman11" <rd******@nooter.comwrote in message
news:b5**********************************@w28g2000 hsf.googlegroups.com...
>this is probably very simple but I don't know. Is there a way to
prevent two people from signing
on to an Access Application using the some login information????

I can't have two people on the application at the same time with the
same user name. I use currentuser for some locking and filtering.

Thanks for any help.

ray
Two suggestions:
1. Provide a unique username/password to each user and tell them not to
share.
or
2. Create a table and store the field CurrentUser() as each person logs in.
Then delete the record when they exit the database. If the record already
exists when somebody logs in, then give them a msg and docmd.quit

Fred Zuckerman

Also, when using suggestion 2, provide a way to 'clear' the CurrentUser-login record !

This is really needed, because at times they will *not* log out the proper way. (e.g. crash or network failure)

You could create a macro 'DiscardCurrentUserLogInRecord' to do the following
--Let them in (don't write a record when the record exists) or...
--Clear the record and quit (so they can log in again the usual way)
You would need another shortcut with the /x switch to run the macro.

Arno R
Dec 4 '07 #3
Arno R wrote:
"Fred Zuckerman" <Zu********@sbcglobal.netschreef in bericht news:Es******************@newssvr13.news.prodigy.n et...
>>"eighthman11" <rd******@nooter.comwrote in message
news:b5**********************************@w28g20 00hsf.googlegroups.com...
>>>this is probably very simple but I don't know. Is there a way to
prevent two people from signing
on to an Access Application using the some login information????

I can't have two people on the application at the same time with the
same user name. I use currentuser for some locking and filtering.

Thanks for any help.

ray

Two suggestions:
1. Provide a unique username/password to each user and tell them not to
share.
or
2. Create a table and store the field CurrentUser() as each person logs in.
Then delete the record when they exit the database. If the record already
exists when somebody logs in, then give them a msg and docmd.quit

Fred Zuckerman

Also, when using suggestion 2, provide a way to 'clear' the CurrentUser-login record !

This is really needed, because at times they will *not* log out the proper way. (e.g. crash or network failure)

You could create a macro 'DiscardCurrentUserLogInRecord' to do the following
--Let them in (don't write a record when the record exists) or...
--Clear the record and quit (so they can log in again the usual way)
You would need another shortcut with the /x switch to run the macro.

Arno R
Also, maybe get the Machine name.
http://www.mvps.org/access/api/api0009.htm

Using LDBView or JetRoster or whatever you can determine who is in the
system. Comparing the machine names to a table can help. If Joe left
the app by crashing and burning, he would not exist so any records of
him in a table could be removed so he could log in.

Dec 4 '07 #4
On Dec 4, 12:25 pm, Salad <o...@vinegar.comwrote:
Arno R wrote:
"Fred Zuckerman" <Zuckerm...@sbcglobal.netschreef in berichtnews:Es******************@newssvr13.news.pr odigy.net...
>"eighthman11" <rdshu...@nooter.comwrote in message
news:b5**********************************@w28g200 0hsf.googlegroups.com...
>>this is probably very simple but I don't know. Is there a way to
prevent two people from signing
on to an Access Application using the some login information????
>>I can't have two people on the application at the same time with the
same user name. I use currentuser for some locking and filtering.
>>Thanks for any help.
>>ray
>Two suggestions:
1. Provide a unique username/password to each user and tell them not to
share.
or
2. Create a table and store the field CurrentUser() as each person logs in.
Then delete the record when they exit the database. If the record already
exists when somebody logs in, then give them a msg and docmd.quit
>Fred Zuckerman
Also, when using suggestion 2, provide a way to 'clear' the CurrentUser-login record !
This is really needed, because at times they will *not* log out the proper way. (e.g. crash or network failure)
You could create a macro 'DiscardCurrentUserLogInRecord' to do the following
--Let them in (don't write a record when the record exists) or...
--Clear the record and quit (so they can log in again the usual way)
You would need another shortcut with the /x switch to run the macro.
Arno R

Also, maybe get the Machine name.http://www.mvps.org/access/api/api0009.htm

Using LDBView or JetRoster or whatever you can determine who is in the
system. Comparing the machine names to a table can help. If Joe left
the app by crashing and burning, he would not exist so any records of
him in a table could be removed so he could log in.- Hide quoted text -

- Show quoted text -
Thanks to everyone who replied. Sorry I didn't get back with you
sooner; I was sent out of town for work.
I ended up doing Fred's idea of keeping track who is signed in by
currentuser(), it worked great. Thanks
again to everyone.
Dec 18 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Catherine Jo Morgan | last post: by
22 posts views Thread by alecjames1 | last post: by
5 posts views Thread by polarz | last post: by
reply views Thread by Raffi Basmajian | last post: by
6 posts views Thread by raylopez99 | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.