Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Can I force user shares to close or logoff

Posted on 2011-09-14
8
Medium Priority
?
392 Views
Last Modified: 2012-05-12
Last night I thought I had logged everyone off their workstations – used my master key to access all but 2 offices. I determined everybody was logged off. Still I got a message that I did not have exclusive access to the Access database which usually means that someone is still logged on the database.

I am using SBS 2008. All workstations are either Vista or Win 7.

How can I have all computers log off after a certain period of inactivity? Or after a certain time of day? Or can I force all user shares to close?
0
Comment
Question by:LostInWindows
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 36540299
Here's a Microsoft article which shows how to detect idle time, and how to logoff users if they exceed your idle timeout period:

http://msdn.microsoft.com/en-us/library/bb243861%28v=office.12%29.aspx

Note, however, that even after logging everyone off, you can still end up with a "hanging" ldb file. If you do, then you'll have to delete the .ldb file (Access will create it as needed).
0
 
LVL 1

Author Comment

by:LostInWindows
ID: 36540305
Is the .ldb file created on the workstation or on the server? If on the server, is it in the Database directory?
0
 
LVL 77

Assisted Solution

by:Rob Williams
Rob Williams earned 1000 total points
ID: 36540310
One solution that was introduced with WinNT that is still used today is the Winexit screen saver:
http://support.microsoft.com/kb/314999

You can also use the Microsoft psshutdown tool to force a text list of computers ,or all using wild card, to close applications and logoff, reboot, or shut down. This could be run as a command, or scheduled event from the domain controller.
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/SBS_Small_Business_Server/Q_27309029.html
0
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 
LVL 1

Author Comment

by:LostInWindows
ID: 36540314
Hmmm, sounds interesting. let me ask...
0
 
LVL 85
ID: 36540326
<Is the .ldb file created on the workstation or on the server? If on the server, is it in the Database directory? >

Assuming you're working with a split database architecture (a Backend consisting of Tables ONLY, and multiple FrontEnds consisting of everything else):

The .ldb file for the Backend will be in the same directory as the Backend, and it'll have the same name. For example, a file named MyBackend.mdb will produce a Lockfile name MyBackend.ldb.

The .ldb file for the Frontend will be on the user machine in the folder that holds the FE database (assuming you've deployed a COPY of the FE to each user). If you haven't deployed an FE to each users, then you'll need to search the target machines for .ldb files and attempt to delete them.
0
 
LVL 1

Author Comment

by:LostInWindows
ID: 36540336
Hi LSM,
There is 1 database located on the server with everything in it. The database has a lot of links to picture files also located on the server.  
All users except for 3 'programmers' are using Access Runtime 2007.
0
 
LVL 85
ID: 36541774
<There is 1 database located on the server with everything in it. >

Then the .ldb file should be on the folder where that database is located. You might also consider rebooting the machine hosting the database, as this will remove all Windows locks on that file.

Further: The database should be split to a Backend and Frontend scenario, and you should deploy a copy of the FE to each user. While you may have been fortunate enough to have no issues so far, you'll eventually run into them - corruption, performance issues, record locking, etc etc.
0
 
LVL 1

Author Closing Comment

by:LostInWindows
ID: 36557238
Thanks for the great suggestions
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
Let's recap what we learned from yesterday's Skyport Systems webinar.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Suggested Courses

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question