You can use FOPEN.
lcDbfName = "h:\mytables\mytable.dbf"
lnFH = FOPEN(lcDbfName, 12)
IF lnFH > 0
=FCLOSE(lnFH)
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
>
--sb--