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