>Working in a network environment using VFP 6.0. I have a main form that has several tables in the data environment. I use a program at specific time intervals to DROP two of the tables and SQL code and ODBC to recreate them and then add these two tables back to the data base. When I do this my main form seems to loose control of these two particular tables. When I run another program that uses these wo tables it says they don't exist. If I run the second program right from the form the tables are found. How do I make the form and data environment reattach itself.
>
>May God Bless
>S. Dyke
Steven,
As an analogy, this is kind of like closing the table/view that a grid is bound to (Uses as a record source) Once the table is closed, the grid forgets it ever existed. What is happening to you hear, from the sound of it anyway, seem a similar situation. Personally I don't use the data environment. I don't use it largely because I wnat more control over the opening, closing, etc... of tables / views. I have a data access object that handles all the opening, closing, inserting, updating, ... etc... for both FoxPro file share data and for SQL Server data. All of our forms work in private data sessions. The form then takes care of its self. In your case, this methodology may require a bit of re-engineering to make work properly, but hopefully it will give you something to start with.
Regards,
Jason
Jason Tryon
Senior Systems Analyst / Technical Lead
eBusiness / iPage