>>>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
>>
>>Neil,
>>First I'd double check COM server is using a private datasession and not keeping tables open all the time.
>
>Hi Cetin,
>
>Thanx again for your help. My COM server is based on the session class. May I assume that the session class will insure that the datasession is therefore private?
>
>Neil
>>Cetin

No never assume it's not. Add :
DataSession = 2
As a property at class definition

Cetin