Re: File in use?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Jay,

Unfortunately, I realize I don't have the alias. Just the table name. How
can I do it under these circumstances?

The most easy way would be: try to use the table exclusively without AGAIN. If the table is open in a different select area or if it is in use by a different workstation then you get some error and the table will not open.
SELECT 0
USE (table) EXCLUSIVE
If empty(alias()) && table did not open
*Table is in use somewhere else
Endif


2) Is there a function that will return the work area that a table is in
use in?
dbf() will tell you the name of the table. So loop through all work areas and check with this function.
aused() will list all work areas with open tables (at least available in VFP8, maybe also in VFP7, check help)

Regards
Bernhard Sander
.

Relevant Pages

  • Re: Errors migrating from NT to 2003
    ... what 's the OS version on the Workstation? ... Best regards, ... Errors migrating from NT to 2003 ... domain groups to a local group on the WS: ...
    (microsoft.public.windows.server.migration)
  • RE: Remembering recipients email address
    ... >Best Regards, ... >| I am transferring a user to a new workstation. ... >| only had to type a few letters of the Recipients email ...
    (microsoft.public.outlook.general)
  • Re: Change local administrator password ? through GPO or push script ?
    ... Did some testing and you are right, it is sended in clear text to the workstation. ... Best regards ... Even if he finds the batch file via network neighborhood ... Add this file via GPO to the Default domain policy>Computer ...
    (microsoft.public.windows.server.active_directory)
  • Re: Replacing a workstation
    ... Waiting is something that I didn't do! ... Best Regards ... you sit at the old workstation while it is a member of the domain ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Remotely access Active Directory.
    ... Regards, ... Microsoft MVP - Directory Services ... Install ... >> the adminpak.msi on your workstation. ...
    (microsoft.public.win2000.active_directory)