Thanks so much - this really worked well.
>You can use FOPEN.
lcDbfName = "h:\mytables\mytable.dbf"
>lnFH = FOPEN(lcDbfName, 12)
>IF lnFH > 0
> =FCLOSE(lnFH)
> * Ok to work with the table
>ELSE
> * The table is open somewhere else
>ENDIF
>
>
>>I'm writing a little utility to data drive the backup of folders by zipping them (mostly data folders of multiple VFP apps on a server)
>>
>>I have a table of the apps, their locations etc.. I have included fields for the name of a dbc and dbf that I know cannot be opened exclusively if anyone is in the app.
>>
>>My thought was to programmatically try to open the dbf exclusively and if that fails, delay trying to zip the data folder.
>>
>>The problem is that if I use exclu successfully and then close the table the DBC is still considered open by Winzip and there is an error when you zip it. (dbf zips fine) CLOSE DATABASES ALL is going to close the database my app is using.
>>
>>Is my solution found in using a different data session or is there a trick to tell the os to release any handle on the dbc?
>>
>>Seems I am missing something easy and obvious
>>
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
