Thank you. I tried the close all from the COM server and I still get the error. Why do you think I have to shut down the win 2k server for the files to be released? Resetting IIS on the win 2k server does not help either.

Neil

>All I can guess is that the 'server' is not actually letting go of the table like you think it is.
>
>Maybe, at least as a trial, you can see if a CLOSE ALL in the COM server code makes a difference.
>
>By the way your use of the term "server", as you use it in "I have an asp.net application running on a win 2k server" is confusing. And the fact of peer-to-peer should be mentioned early when describing such problems.
>
>good luck
>
>
>>Tables are on a win2k prof computer. Network = peer to peer.
>>
>>Neil
>>
>>>Hi Neil,
>>>
>>>What OS are the files stored on? Are you talking about a peer-to-peer setup here or what?
>>>
>>>good luck
>>>
>>>
>>>>Hi,
>>>>
>>>>That is very interesting. But....the files are not on the win2k computer. Does that matter?
>>>>
>>>>Neil
>>>>
>>>>>I've seen this if Oportunistic locking is enabled on server. Files remains open even all aplications are closed.
>>>>>Try to disable oportunistic locking
>>>>>Check here:
>>>>>http://support.microsoft.com/default.aspx?scid=kb;EN-US;296264
>>>>>
>>>>>
>>>>>
>>>>>>Hi,
>>>>>>
>>>>>>I have an asp.net application running on a win 2k server. The data tables are not on the win2k server. The data tables are on a second computer on the network. Some of my web forms instantiate a single threaded vfp COM server, which runs a SQL query against a free fpw2.6 table and then lets go of the table. The second computer connected to the win 2k server is running an old fpw26 application against the same tables. The old fpw2.6 application is running on the second computer at the same time that the asp.net application is running on the win 2k server. Both computers access the same tables, which are on the second computer. The asp.net app uses impersonation to gain access to the fpw26 tables. At the end of the day we attempt to reindex the tables from the old fpw26 application and we get errors. The errors indicate that someone else is using the files. We know that no one is hitting the web forms, hosted by the win 2k server, because we can control all of our users
>>>>>behavior.
>>>>>> To clear the problem I shut down the win 2k server. Then the second computer can reindex the tables. Why can the two computers share the tables all day but an attempt to get exclusive use of the tables, when no one is hitting the web forms, results in this error. Why do you think that the win 2k server is holding onto the files? Might it have something to do with the vfp single threaded com server?
>>>>>>
>>>>>>Neil