Michel are you closing all the tables at the end of your request?
That looks like a caching issue since now you keep ur connection always open the resources never gets released is jut like if you had the application always running, My 1st tought was that you may have access the tale with a select statment and never closed, but if that was the case then you should not be able to modify the structure of the table.
>Here is an interesting situation with the VFPOleDB data provider. Now, I am using it in a global mode, which means that I create the connection at startup and use that connection for any SQL request. This works well and it also provides an increase of performance. If I go in VFP and update the structure of one of the table in the directory and issue another request to the Web site, the application cannot see the updated structure. I had to IISRESET /RESTART in order for the application to see the update. Is this normal?
Alexandre Palma
Senior Application Architect