Solved

Can I force user shares to close or logoff

Posted on 2011-09-14
8
388 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
  • 4
  • 3
8 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 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 250 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 1

Author Comment

by:LostInWindows
ID: 36540314
Hmmm, sounds interesting. let me ask...
0
 
LVL 84
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 84
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

756 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