Open Files

[Teutonic]

I am using FPW 2.6 with Windows 2000. Wasn't there a function or utility (Foxtools maybe) that can show who has a certain dbf open? I cannot seem to find it.

Thanks in advance

 

[rgbean]

Nope, unless your program keeps track of it, this is only available at the server - and different OS's (Win9x, NT, 2000, Novell, Unix, etc.) would all have different methods to get this information.

There may be 3rd party tools (NetLib?) that might handle some of these servers "generically".

Rick

 

[ramani]

1. I cannot think of OS returning the name of user who is using a specic file. May be some other expert can tell us about that.
2. I can tell you a way to findout using FoxPro tables.
You can have a myUsers.dbf with one record for each user. The fields can be User Name, his ID, login name etc. This file can be read by the user when application starts up and lock his record. the file shall be kept open thru out his scession so that the lock is intact. Any accidental quit/booting etc will auto unlock the record. The benefit is , by scanning the file and using rlock() function, you can identify who are all loged in at a given time.

Hope the idea is helpful to you.
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[Guest_imported]

see thread <U>182-91429</U> too.

netwatch.exe might be somewhat helpful, but you can't
filter by filetype (.dbf), so you see lots of files.

 

[Kirit]

Do any of you know tool to check net traffic within small office from node to server and node to node, route trace, find bottle necks etc.. Free ware prefered on Novell Netware 3.12 and DOS

Kirit Shah H & H Computers

 

[jesse23]

If you are running Windows (NT, 2k.. don't think 9x supports it) and the connections to the database are coming over your network in through Shares on the computer (i.e., using windows mapped drives or uncs), you can simply run 'net files' on the server to get a list of *all* files opened over the network on that server. If there are tons of files you may want to pipe to a text file, or pick up a windows version of less or grep... you can also use the server manager tool (srvmgr.exe) if you deal better with gui tools. for nt wkstn or 2k prof. you'll need to copy off of a respective type server...
the net files command will also work on os/2... ugh.