Paul The "close database all" operates on the current datasession, so can't you simply open a new datasession to open the database in, do your bits and pieces, then close databases all and return back to the original session.
Obviously if you need data from tables in the first session this will close problems, but you can always open the original database again in the new session as well. Dave Crozier -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Newton Sent: 03 October 2007 12:47 To: [email protected] Subject: Erasing a temporary DBC Hi I am working on modifying an existing piece of code. When this code runs there are several databases (DBCs) already open and I need to leave these open after my mods have been run: Beginning part of original code My Code Last part of original code In my code I am creating a temporary DBC, and subsequently adding and dropping tables. I am ensuring that none of the tables belonging to Temp.DBC are open when I am through. Now I want to ERASE the Temp.DBC (etc) files from disk and cannot do so because I cannot find a way to close Temp.DBC Any suggestions ? Also how can I save (and restore) the current database setting (before and after my code) Thanks Paul Newton [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
