Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / October 2004

Tip: Looking for answers? Try searching our database.

Multiple logins?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Melvis - 05 Oct 2004 14:17 GMT
Hi!

Does Access user level security allow for multiple logins by the same user?
The reason I ask is that I want to set up user accounts for each
organization, and I do NOT want to have the possibility of having more than
one person from each org in the database at a time...

Thanks for your help!
~MATT
Rick B - 05 Oct 2004 14:25 GMT
Have you tested this?

Why not sign on to your computer, walk to another on the network, and sign
on again.

Much faster than wasting time asking experts to tell you.

> Hi!
>
[quoted text clipped - 5 lines]
> Thanks for your help!
> ~MATT
Melvis - 05 Oct 2004 14:33 GMT
No - my database is not complete. I was asking in an attempt to decide
whether or not this type of security would do what I need it to do before I
go through the trouble of setting it up. Sorry if I wasted your time...

> Have you tested this?
>
[quoted text clipped - 14 lines]
> > Thanks for your help!
> > ~MATT
Jack MacDonald - 05 Oct 2004 15:58 GMT
Yes - multiple logins are allowed.

>Hi!
>
[quoted text clipped - 5 lines]
>Thanks for your help!
>~MATT
Melvis - 05 Oct 2004 17:45 GMT
Thank you. Is there any way to turn this off?

> Yes - multiple logins are allowed.
>
[quoted text clipped - 7 lines]
> >Thanks for your help!
> >~MATT
Jack MacDonald - 06 Oct 2004 03:09 GMT
YOu can force Access  to open the application in Exclusive mode (Tools
> Options > Advanced). Otherwise, you could to code something into
your application that recognized the duplication and stopped a second
instance from running. You might find some code on
http://www.mvps.org/access/ that will detect whether a particular user
is already running the application.

>Thank you. Is there any way to turn this off?
>
[quoted text clipped - 9 lines]
>> >Thanks for your help!
>> >~MATT

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
Melvis - 06 Oct 2004 11:07 GMT
It's ok if multiple people with different userids are logged in. What I am
wondering is if two different people could log in using the same userid at
the same time...

> YOu can force Access  to open the application in Exclusive mode (Tools
> > Options > Advanced). Otherwise, you could to code something into
[quoted text clipped - 21 lines]
> remove uppercase letters for true email
> http://www.geocities.com/jacksonmacd/ for info on MS Access security
Jack MacDonald - 07 Oct 2004 01:23 GMT
yes

>It's ok if multiple people with different userids are logged in. What I am
>wondering is if two different people could log in using the same userid at
[quoted text clipped - 25 lines]
>> remove uppercase letters for true email
>> http://www.geocities.com/jacksonmacd/ for info on MS Access security

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.