>In my app I programatically add two tables to the database on startup then programatically add them to the dataenvironment of my main form. Periodically I drop the tables and then add them back(they are ODBC linked to an AS400 data source). As long as I run only one instance of the app all goes good. However, when I try running another instance when the update occurs I get an error when the tables are to be droped saying file access is denied. I have tried the RemoveObject on the second instance to remove the cursors from the dataenvironment before the update but that dosen't help. It seems the tables are attached to the instance. Please help.
>

My suggestion would be to re-think your overall process here. You say this is an ODBC link to a remote datasource. So are these really remote views instead of tables? Why are you dropping and re-creating in the first place? This should not be necessary if the source table structure is not changing.

Is the data updatable? Are you using SQL pass-thru to retrive the data? Please help with a few more details.