I have a class module in Access, whose objects hold a connection to an SQL7 database. I have one database per object plus a database for administering the other ones.
When I want to delete an object permanently, I close that object´s connection to its db, set the object to nothing and then use the "administative" db to drop the database for the object that I want to delete. This doesn´t work. I get an error message saying that the database cannot be dropped because it is in use, even though i have closed the connection. I have even tried waiting for a few seconds after the connection was closed before I tried to drop the database, but it still didn´t work. Why does SQL7 consider the database still in use and what can I do to tell it not to?
/gny
When I want to delete an object permanently, I close that object´s connection to its db, set the object to nothing and then use the "administative" db to drop the database for the object that I want to delete. This doesn´t work. I get an error message saying that the database cannot be dropped because it is in use, even though i have closed the connection. I have even tried waiting for a few seconds after the connection was closed before I tried to drop the database, but it still didn´t work. Why does SQL7 consider the database still in use and what can I do to tell it not to?
/gny
