>Is there any way of telling which user on the network has a particular file open - we run overnight runs which pack and reindex the most important tables and they very often fall over because an unknown user has a file open
>

Check http://www.berezniker.com/content/pages/visual-foxpro/who-has-files-open-network