Cannot open exclusive

[RipperT]

Hello,
I am in the test stages of developing my database. I have user level
security implemented and it works well. My problem is that I have attempted
to open the DB in exclusive mode (as the admin) which I believe is supposed
to lock out others. It is not working. I am making sure that all users are
logged off first (only two others even have access, and they don't have
permission to open in exclusive mode), then I open exlusive, then they are
still able to open and use it. The DB is split, with a copy of the front end
on each of the others' machines. Can anyone explain why this is happening?
Many thanx,
Ripper

 

[Lynn Trapp]

Are you trying to open your copy of the frontend in exclusive mode or are
you trying to open the backend in exclusive mode?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[RipperT]

Are you trying to open your copy of the frontend in exclusive mode or are

you trying to open the backend in exclusive mode?

My copy of the front end.

Rip

--
Ripper T Smith
rippertsmith<nospam>@comcast.net

Are you trying to open your copy of the frontend in exclusive mode or are
you trying to open the backend in exclusive mode?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Lynn Trapp]

Then why do you say it is not working. You are the only one trying to open
your copy of the front end.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

Are you trying to open your copy of the frontend in exclusive mode or are
you trying to open the backend in exclusive mode?

My copy of the front end.

Rip

 

[RipperT]

Point taken. I'll rephrase.

4 times a day, I will need one user (who belongs to a group with proper
permissions) to open the database for about 20 minutes and verify some
information, during which time it is IMPERATIVE that the data in the
underlying (back end) table not be altered. What's the best way to
accomplish this?
Thanx,
Ripper

 

[Lynn Trapp]

Well, to guarantee that you are going to have to insure that no one else has
access to the backend. That means you will either need to ask everyone to
exit the database or, else, boot them out. I believe I remember that Tony
Toews has a utility for doing that (but don't quote me there, you'll have to
look around his site to see if that's correct) --
www.granite.ab.ca/accessmstr. Obviously, people doen't really like being
unceremoniously booted out of an application, so you might find it more
applicable to just make an announcement at the appropriate time that people
must exit the database. You threaten the removal body parts for those who
don't...LOL.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[Fred Boer]

Dear Rippert (and Lynn):

I don't know about Tony's site, but I *do* know about the following:

Roger Carlson has sample solution(s) on his website at:

http://rogersaccesslibrary.com/TableOfContents3.asp#K (Look for
"LogUsersOff"...)

Arvin Meyer has another sample solution at:
http://www.datastrat.com/Download2.html (Look for "KickEmOff"...)

Cheers!
Fred Boer

 

[Lynn Trapp]

Fred,
Those are probably the sites I was thinking of.

Thanks,

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[RipperT]

Thanx, guys, I will check out the sites you mention.

Rip