permission/rite to close open files

  • Thread starter Thread starter djc
  • Start date Start date
D

djc

I have a consultant that has access to a server for development and
maintaining a database system. She has full access to a SQL 2000
installation. However, there are times where she needs to close other users
open files and I would like to allow her to do that. When I do this, I use
the computer management mmc where I can view and close open files on that
server. What can and/or what should I do for her to allow her to close open
files?

more info: its only a handfull of files she may need to close. The issue is
that some people may leave a workstation on and connected to an access
database which means the developer cannot get the needed exclusive access to
the backend file to work on it.

any info is appreciated. Thanks.
 
If she has administraor access to the server then she should also be able to use
Computer Management or else see the link below. --- Steve

http://support.microsoft.com/?kbid=290585

Command to Close All Open Files
for /f "skip=4 tokens=1" %a in ('net files') do net files %a /close

The command works by passing the file ID elements from the list produced by the
net files command to the action argument of the for command, net files file ID
/close. When you use the iterative substitution (%a in this case) as part of a
batch file, the substitution needs to be %%a. For the batch file version of the
command, use the following syntax:
for /f "skip=4 tokens=1" %%a in ('net files') do net files %%a /close

In both cases, this command will appear to return an error because the last line
of output from net files is "The Command Completed Successfully" and there is no
file ID denoted as "The".

Note: The Server Service must be running in order for this command to work.
 
when I said 'full access' before I meant to the SQL Server 2000 installation
only. Not the OS. What is the minimum I need to do to allow her to close
open files? Currently she is only a regular user to the OS. I have granted
her the rite to restart the computer as they may be required for her work.
However she can't close open files. I don't want to make her an admin or
even server operator. That is way overkill. There must be a way to simply
allow her to close open files.

anyone?
 
Back
Top