Steve
I need to create an extract table of selected records from a larger data set for use on a web server. This will be done at midnight, kicked off by a timer. However there is a possibility(however remote) someone may be querying the data at the same time I am coping the new file over. In that case I want to keep checking until no one is using the file then overwrite the old extract file.

I use a sql statement in the web page to grab only the data pertinent to that user from the extract file and then immediately close the extract file. My thinking is there is a remote possiblity of conflict, but I would like to provide for it.

All this will be unattended.

If there is better way of doing this I would appreciate your thoughts?
The client really doen't want me going against their corporate data from my web application. They want me to use extracted data.

Thanks for your quick response

Gaylen

>
>Is this a VFP table? If so, the most reliable method is to try to open it exclusively. You have to trap the error that will occur if someone has the file in use.
>
>See Re: Check for Exclusive Open? Thread #741115 Message #741147
>
>< UPDATE >
>
>What are you going to do if someone has the file open?
>
>>How can I determine if a file is being used by someone on the network. I need to copy some files daily but need to determine if the old file is being used.
>>
>>Gaylen